I also use the following on my “Index” (kind of a start page) to show recently edited and recently created files (excluding the Index file itself):
TABLE file.mtime as Edited
WHERE date(now) - file.mtime <= dur(3 days) and file.name != "Index.md"
SORT file.mtime desc
TABLE file.ctime as Created
WHERE date(now) - file.ctime <= dur(3 days)
SORT file.ctime desc
Probably this will be more useful later, when live updating is added (it is on the roadmap on GitHub, if I’m right).
I don’t know who posted something like this first on the Discord, maybe it was @SkepticMystic?
Edit: There was a bug before version 0.1.8 that required to write
>= instead of
<= in the examples above. I now adjusted it to work in 0.1.8 and later.