This goes from relatively simple to relatively complex pretty fast.
First of :block/refs doesn’t get what you need.
Also you want the block on the page and not the parent of the block, though in this case that is the same, but if your task is under a parent block you won’t retrieve it.
Next getting a namespace is only 1 level deep, and here’s where the complexity comes from.
I’m going to assume you don’t want that to be static
So I use rules to create a recursive search to find all pages under project, no matter their dept.
Here’s the query I created:
Yes. :block/name is always lowercase. I forgot to mention, I generally add that for clarity!
Pages have 2 names, one is lowercase and stored in the attribute :block/name and the other is their original name case stored in :block/original-name.
I generally use :block/name so we don’t have to think how exactly we wrote the name of a page
For filtering priority we have the attribute :block/priority
So we will need to add the line: [?b :block/priority "A"] to the query.
Alternatively we can do this the same way as we did for the task itself.
Hi there @Siferiax , many thanks for the solution… its nearly perfect.
If you allow one last question:
Sometimes i would also note some tasks in the root layer of a namespace (“project/…”).
Is it possible to include these tasks with priority into the query results?
i already found the great Query-Builder-Tool from adxsoft
but couldn’t figure out how to build a recursive query for the namespaces like the one @Siferiax provided. Maybe its just a matter of time learning the nuances of datalog.
For now the hints from Siferiax provides a very powerful solution for project management in Logseq.
But now I’m trying the following as the inverse - i.e. find all todos that don’t have any project tags, but it’s finding no results (despite the fact that I’ve created some test todos without project tags). Any idea how I can fix this? Thanks very much in advance!