Pages with at least one pending task

Questions & Help Queries
1

Hello Hello,

I would query all the pages where there is at least one “TODO” … and I don’t know how to do it :smile:

I can get the list of the tasks, group them by pages, but this is not what I’m looking for.

My scenario is to use a page as a “Topic” which sometimes includes an action (let’s say “anniversary” page may have a task to buy a gift for the upcoming ones)
With the list of page, I will be able to hover page names and read the actions on the page (top section)

Simple query does not seem to answer this and I’m not good enough with advanced queries :face_with_open_eyes_and_hand_over_mouth:

Thanks in advance for any pointer or hint :smiley_cat:
Anne.

2

Something like this:

#+BEGIN_QUERY
{:title "Pages with TODOs"
 :query [:find (pull ?p [*])
   :where
     [?b :block/page ?p]
     [?b :block/marker ?marker]
     [(contains? #{"TODO"} ?marker)]
 ]
}
#+END_QUERY
1 Like
3

Hello mentaloid,

So elegant … :star_struck:

Didn’t expect to get the answer faster than a pizza delivery :joy: you made my day :bowing_man:

Cheers,
Anne.

1 Like
4

I personally prefer to just open the TODO page and all todo’s will be there in linked references.

1 Like
5

Is it possible to also include a specific tag?

6

Welcome, add these lines:

[?b :block/refs ?ref]
[?ref :block/name "specific tag's name in lower-case"]
7 
#+BEGIN_QUERY
{:title "Pages with TODOs"
 :query [:find (pull ?p [*])
   :where
     [?b :block/page ?p]
     [?b :block/refs ?ref]
     [?ref :block/name "darc"]
     [?b :block/marker ?marker]
     [(contains? #{"TODO"} ?marker)]
 ]
}
#+END_QUERY

It does not work, if I do it with tag only it works, if I do it with the TODO ist works, but both together dont delivers anything

8
  • It works to me.
  • Please share some blocks that (their page) should be delivered.
9

I post here an example. I have many pages for business travels where I want to be reimbursed. And I use logseq to track all of them:

- Dienstreise
  template:: Dienstreise
  template-including-parent:: false
	-
	  tags:: #Dienstreise
	  icon:: ✈️
	  dienstreise-reisender::
	  dienstreise-start::
	  dienstreise-ende::
	  dienstreise-kosten::
		- TODO Konferenzregistrierung
		- TODO Hotel
		- TODO Bahn
		- TODO Flug
		- TODO ÖPNV
		- TODO Dienstreiseantrag
		- TODO A1 Bescheinigung
		- TODO Dienstreiseabrechnung
		- TODO Erstattet

For each travel I have an own page. So its not that for each travel I have one block in a travel page, I really have one page per travel.

10
  • In your example the tag is in an ancestor block.
  • One way is to use :block/path-refs, which looks-up the tags of all those blocks:
    [?b :block/path-refs ?ref]
[?ref :block/name "dienstreise"]
12

Okay better, and If I want to have the tags #dienstreise and an additional one #foo?

And furthermore, how can I select all pages that have no TODO at all?

13

Just add another couple of lines, but with a different variable (e.g. ?foo-ref or here ?ref2):

[?b :block/path-refs ?ref2]
[?ref2 :block/name "foo"]

It depends what you mean by this. But it needs a separate thread.