In my case i have 3 references
[[Meeting]] with [[Siferiax]] and [[Fede]]
In the query I add the code
(not [?t1 :block/name "meeting"])
not to consider the page meeting.
How to get the TODO in common between Siferiax and Fede?
I tried this but it is not working
#+BEGIN_QUERY
{ :title [:h6 [:mark "QUERY"]]
:query [:find (pull ?b [*])
:in $ ?parent
:where
[?parent :block/refs ?t1]
[?parent :block/refs ?t2]
[?parent :block/refs ?t3]
[(!= ?t1 ?t2 ?t3)]
(not [?t1 :block/name "@meeting"])
(not [?t2 :block/name "@meeting"])
(or-join [?b ?t1]
[?b :block/path-refs ?t1]
(and [?t1 :block/alias ?a]
[?b :block/path-refs ?a]))
(or-join [?b ?t2]
[?b :block/path-refs ?t2]
(and [?t2 :block/alias ?a]
[?b :block/path-refs ?a]))
[?b :block/marker ?marker]
[(contains? #{"LATER" "NOW"} ?marker)]
(not [?var :block/refs ?b]
[?var :block/parent ?parent])
]
:inputs [:parent-block]
:table-view? false
:result-transform (fn [result]
(sort-by (fn [m]
(get m :block/marker)) > result))
:breadcrumb-show? false
:collapsed? false
}
#+END_QUERY