Dataview: Querying for uncreated files

Help
4

I’ve worked a bit on the query and came up with this

TABLE without id 
out AS "Uncreated files"
FLATTEN file.outlinks as out
WHERE !(out.file) AND !contains(meta(out).path, "/")
GROUP by out
SORT out ASC

This way only uncreated files are being shown and there are no multiple entries if multiple files link to the uncreated file and file names with “.” in the name won’t be filtered out.

and here’s another table query that sorts by uncreated file and also lists the files where the links to the uncreated file originate from.

TABLE without id 
out AS "Uncreated files", file.link as "Origin"
FLATTEN file.outlinks as out
WHERE !(out.file) AND !contains(meta(out).path, "/")
SORT out ASC
1 Like