Dataview, Searching google etc. - haven’t found any plugin that supports custom filters for file opening
I’m trying to automate my obsidian experience, and with that came the need to re-open the last-created file - considering that I’m using Obsidian for school, I would also like it to search only for a given subject. The Dataview plugin has SQL support which I’m using, and I was wondering if It’s possible to assign a SQL query to hotkey, which opens a note if it finds any matches.
Eg. SQL that I would like to use to open a file:
TABLE FROM "School/Maths" SORT file.ctime DESC LIMIT 1
I’m sorry if this is cluttering the forum, I’m a newbie to it.