I am trying to list all the notes from my Notes folder where the value for Organization equals the name of the page containing the query, so that the same query would list all notes for [[Org A]] on the [[Org A]] page and all the notes for [[Org B]] are listed on the [[Org B]] page.
Instead of making a unique query for each unique page, like on page Org A:
TABLE Date, Type, Number FROM "Notes"
WHERE contains(Organization, [[Org A]])
SORT Year asc
and on page Org B:
TABLE Date, Type, Number FROM "Notes"
WHERE contains(Organization, [[Org B]])
SORT Year asc
What I’ve tried
TABLE Date, Type, Number FROM "Notes"
WHERE contains(Organization, this.file.name)
SORT Year asc
On the contrary, on the contrary (now @Koen have all the issues covered).
I’m used to start by previous steps to avoid unnecessary replies as “It doesn’t work”.