Another query on todo questions

Hi, im struggling with the queries.
I found a good answer by sirifax, but it is not working for me (“no match result”). And i dort know why.

What is my need.

In the Journal, im adding blocks per project (“project aaa” and “project bbb”). the project name also is a page name.
inside, i drop TODOs if needed.

now. on the projects page, i see all TODOs inside the linked references. thats ok, but i want to see all TODOs in the top of the page (for now, lets say “just all todos”).

when i use the answer of this question, i get nothing ( How to query all TODOs from a given page? - Queries - Logseq)

when i use the query builder with

{{query (and [[Project AAA]] (task TODO))}}

i see the TODOs, but with some “stuff” before (the owning bullet, the date/title of the journal).

Question:
is there a way for quering the “raw” TODOs related to the page as a plane todo list/table?

Side Quest
Ive seen many questions on that, and the queries there are all fantastic, but

  • they are not returning any results for me
  • i dont get the query syntax (it just looks strange)
  • i dont found a documentation on that.

if someone has a reference on that, this would be great

Example from before :

#+BEGIN_QUERY
{:title “My Project TODO”
:query [:find (pull ?h [*])
:where
[?h :block/marker ?marker]
[(contains? #{“NOW” “DOING” “TODO” “LATER” “WAITING”} ?marker)]
[?h :block/page ?p]
[?p :block/name “project gmdm”] ;name is always lower-case
]
:result-transform (fn [result]
(sort-by (fn [h]
(get h :block/priority “Z”)) result))
:group-by-page? false
:collapsed? false}
#+END_QUERY

Have you tried switching to table view from the top-right of the query results?

  • Unfortunately, it is what it is. But read the Query Reference.
  • You have been in IT, so it should gradually make sense.

Read the examples in the documentation. Make sure that these work, before trying more complicated ones.

Share here some of the blocks that you would like to appear as results.

Perfect. The links are the missing parts i wasnt able to find. Thx for this.
The tip with table-view is also good, not exactly what i was looking for, but now i can play around with the queries.
Cheers.

for the records: a good overview on YT on this topic: LogSeq Advanced Query - Basics & Tips in less then 10 min (youtube.com)