Query TODOs with tags does not work

Questions & Help
1

I was making a qeury that only shows TODOs within pages that has a property stat:: #private

#+BEGIN_QUERY

{
 :title [:h3 "private TODOs" ]
 :query [:find (pull ?b [*])
 :where
         [?b :block/page ?p]	
         (property ?b :stat "private")
         [?b :block/marker "TODO"]
 ]
}

#+END_QUERY

But it returns nothing. Where did I go wrong?

This is my sample page

image
image2168×1750 135 KB

2

But your line:

(property ?b :stat "private")
  • uses property instead of page-property
  • uses ?b instead of ?p

Try this line instead:

(page-property ?p :stat "private")
1 Like
4

Sorry for the late reply. So this is the modified query according to your suggestion -
(edit for direct reply)

#+BEGIN_QUERY
{ 
:title [:h3 "private TODOs" ] 
:query [
 :find (pull ?b [*])
 :where 
   [?b :block/page ?p] 
   (page-property ?p :stat "private") 
   [?b :block/marker "TODO"] 
 ]
}
#+END_QUERY

However it does not seem to grab the TODO block under the page. I’m sure there’re some of them. I’ve again added the page referenced as following. Are there any instructions I didnt follow?

image
image2748×1824 153 KB

5
  • Page properties should be in the first block of the page.
    • But currently your first block is Description, so your page has no properties.
    • If you move the properties to the first block, the query will work.
  • If you need to break that convention and use another block, try something like this:
    #+BEGIN_QUERY
{
:title [:h3 "private TODOs" ]
:query [
  :find (pull ?b [*])
  :where
    [?pb :block/page ?p]
    (property ?pb :stat "private")
    [?b :block/page ?p]
    [?b :block/marker "TODO"]
  ]
}
#+END_QUERY
1 Like