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.

[blandry]

I feel that these queries are almost what I need.
I am having trouble finding a query that will work for the following workflow:

1. I use the journal in Logseq to log actions and todos for the day. As a simple example for the journal page for the last two days:

[[2025-05-01]]
     - stuff occurred two
     - stuff occurred three
     [[project/PlanParty]]
          - worked on tables 
          TODO email Bob
     [[project/Cookout]]
          - worked on grill
          TODO pick up meat

[[2025-04-30]]
     - stuff occurred one
     - stuff occurred two
     [[project/PlanParty]]
          - worked on tables
          TODO call Gregg
     [[project/Cookout]]
          - cleaned area
          TODO cut grass

2. Now, I would like to build a query that will produce the following results:

Todos for All Namespace Projects:
[[project/PlanParty]]
     TODO call Gregg
     TODO email Bob

[[project/Cookout]]
     TODO pick up meat
     TODO cut grass

Any help would be most appreciated.
@Siferiax

[mentaloid]

If you are trying to group by project, try the approach in A list of next tasks grouped by projects