Help with tasks query

Questions & Help Queries
1

Hi everyone,

I struggle with a query that finds TODOs in my current page and blocks linked to it. Results are ordered by priority. For the moment that is almost everything I need. But one thing would be nice: I am looking for a way to group the query results by priorities and make the groups visually more clear. Ideal would be styled grey boxes per priotity, as there are in default queries for pages.

Here is my query so far:

#+BEGIN_QUERY
{:title [:b "TODO List current page, sorted by priority"]
 :query [:find (pull ?b [*])
   :in $ ?current
   :where
     [?b :block/marker "TODO"]
     [?p :block/name ?current]
     [?b :block/path-refs ?p]]
   :result-transform (fn [result]
                      (sort-by (fn [h]
                                 (get h :block/priority "Z")) result))
:inputs [:current-page]}
#+END_QUERY

Any help is appreciated!
Cheers Falko

2

Hello there! Just discard my suggestion if you find it too simple, innocent or inadequate - I just found logseq one month ago!
I use a simple live query for TODOs,

{{query (task TODO)}}

In my use case, this simple approach works really well - I believe I’ve seen it on a tutorial. I also combine it with a DONE live query on the same page

{{query (task DONE)}}

This way I’ve everything (task-related) on a page - I did not have messed with priorities yet.

Hope it helps somehow!

3

Hi,

my query includes only blocks related to the current page. So I can see what has to be done with respect to a certain page. Also i sort by priority. I would like to improve the display of the results by grouping by priority.
Also i have standard queries that also filter for scheduled tasks.
To my knowledge the additional functionality of my queries is not available in basic queries.

Best regards

4

Check query discord Discord , you can find there examples and Claude skill, use claude with this skill to create any queries you want, making them by hand is too hard