Non-completed tasks in daily notes
TASK FROM "Areas/Daily Notes"
WHERE !checked
Biggest files
TABLE round(file.size / 1024) AS "File size (KB)"
FROM ""
SORT file.size DESC
LIMIT 10
Recent notes
TABLE file.folder AS "Folder"
FROM ""
SORT file.mtime DESC
LIMIT 25
Ideas
LIST FROM #idea
Linkedness of Evergreen Notes
TABLE length(file.inlinks) as Inlinks, length(file.outlinks) as Outlinks, length(file.inlinks) + length(file.outlinks) as Total
FROM "Evergreen"
WHERE !startswith(file.name, "+")
SORT length(file.inlinks) + length(file.outlinks) DESC