I’m interested in this too, I have a page for general todos on which I want to list todo’s from other pages too:
#+BEGIN_QUERY
{:title "TODOs from other pages"
:query [
:find (pull ?b [*])
:where
[?b :block/marker _]
(not [?b :block/marker "DONE"])
[?b :block/page ?p]
[?p :page/journal? false]
(not [?p :page/name "Misc todos"])
]
:result-transform (fn [result]
(sort-by (fn [r]
(get r :page/name)) result))
}
#+END_QUERY
Without the :result-transform
I get the page names in the blocks, but they disappear when the :result-transform
is added.