Find all tasks under blocks tagged with project namespaces?

[Siferiax]

Check out this post:

Queries for task management

A fun one today! Tasks that don’t reference a page regardless of nesting This will exclude any tasks that are referencing a page or that one of the parent blocks references a page. This query uses rules for recursive searching. To change this to reference instead of don’t reference, just remove the (not and closing ) around (check-ref ?p ?b) #+BEGIN_QUERY {:title " TODO" :query [:find (pull ?b [*]) :in $ % ; % is used to pull in the rules below. :where [?b :block/marker ?marker]…

(Sorry doing this from a hospital bed on my phone but thought I could at least point you in the right direction)

[logseq-lion]

Omg, you’re my savior - this works perfectly. For whatever reason you’re in the hospital - I hope you get well soon!

[Siferiax]

Thanks. Had emergency surgery, but I’m back home and recovering just fine.

[veliger]

This thread is so helpful! I would like to sort the output by project - right now it is sorted by date of journal entry.

I tried adding:

:result-transform (fn [result]
                                 (sort-by (fn [h]
                                                  (get h :block/name)) result))

With no change

[Siferiax]

It outputs blocks, not pages. So we need to first get the page.
(get h :block/name)
Needs to be (get-in h [:block/page :block/name])

[Scott_Ivell]

@Siferiax can you please add that sort criteria into the original query and republish? something im not understanding - thank you!

[Siferiax]

Which query do you mean exactly? There is a bunch of queries posted in this thread and I’m not sure which you refer to.