Interactive Inbox Management Query

Share & showcase
1

This has been very useful to me for years now, and has been refined to near perfection.

It leverages the Advanced URIs plugin with Dataview to interpolate links into the actual query results - helping me to very efficiently & quickly perform actions on the files!

(primarily, used to file new files into their respective categories & folders)

for example:

I have a folder specifically for gardening notes, and I’ve created 3 new gardening note files today:

Screenshot_20240612-130226
Screenshot_20240612-1302261080×725 61 KB

It is very simple & easy to identify the notes that need to be filed, and use the ‘Move’ button to put them where they belong.

(or even the ‘Delete’ button when I identify duplicate files).

query code:

	TABLE WITHOUT ID 
	
	file.link AS "", 
	
"[Move]" + "(obsidian://advanced-uri?&filepath=" + replace(file.path, " ", "%20") +
"&commandid=file-explorer%253Amove-file)"
AS " ", 
	
	"["	
	+ "Delete"
	+ "]("
	+ "obsidian://advanced-uri?&filepath="
	+ replace(file.path, " ", "%20")
	+ "&commandid=app%253Adelete-file)"
	AS "  "
 
 WHERE contains(file.path, "02.02 - Inbox Main") 
	
LIMIT 99

SORT file.cdate

ideas for enhancements:

  • A query to list files created in the last day
  • a “rename” button (etc.)
3 Likes
2

Another very similar query that I use to help clean up empty files that are created inadvertently:

Screenshot_20240612-132824
Screenshot_20240612-1328241080×588 58.1 KB

query code

	TABLE WITHOUT ID
	
		file.link AS "File",
		
		file.size	AS " size", 
	
	"[Move]" + "(obsidian://advanced-uri?&filepath="
	+ replace(file.path, " ", "%20") +
	"&commandid=file-explorer%253Amove-file)"
		AS " ", 
	
	"["	
	+ "Delete"
	+ "]("
	+ "obsidian://advanced-uri?&filepath="
	+ replace(file.path, " ", "%20")
	+ "&commandid=app%253Adelete-file)"
	AS "  "
	
		
		
		
	FROM ""
	WHERE file.size = 0 OR file.name = "Untitled"
	SORT file.size ASC
2 Likes