This query is meant to look for any outlinks that contain the current date from the file title.
The reason I do it that way is because sometimes I have timestamps and sometimes the links are just dates ie. [[Sun Mar 09 2025]] or [[Sun Mar 09 2025 10:30]] and I want to catch them all. And sometimes the link doesn’t lead to an existing note which is why I use meta()
ie. [[Sun Mar 09 2025]] leads to the daily note so the file exists but [[Sun Mar 09 2025 10:30]] leads to nowhere but I still want that link to be found in any notes mentioning that date so I can have a full list of any note that mentions that date.
list
flatten file.outlinks as out
where
contains(meta(out).path, dateformat(date(this.file.name, "ccc LLL dd yyyy"), "ccc LLL dd yyyy"))
sort file.mtime desc
group by file.link
It does work well but it sure is an intensive way of achieving this and takes over 10 seconds to run on my vault.
So I’m looking for suggestions on how to optimize this query. Anyone?
Thanks!