Retrieve actions from sub list of items

[gaufff]

Apologies, wrong title

This is a continuation of my previous post: Retrieve list of bullet points and their sub items

Thanks to you and your help, I have a lovely dataview query that allows me to retrieve sub-bullets from a list that starts with a certain hashtag:

My daily notes, let’s say from 2024/09/25, contain stuff like

• #4B
  • 4B stuff
• #5E
  • 5D stuff

And the following query:

LIST item.children.text
FROM #5E
FLATTEN file.lists as item 
WHERE contains(item.tags, "#5E")
SORT file.day DESC

Nicely returns this:

• 2024-09-25 (Wed)
  • 5E stuff

I’d like to go 1 step further and use that structure to organise my tasks.

For now, I sometimes have a “5D stuff” which is a task, and it is captured by my query, flattened as an item. I can keep it, but I’d like a special query that would only extracts tasks.

It should ideally be output as a task list, but if it is flattened as an item, I don’t mind, I just want an overview of tasks per category.

Can you please help me finetune the query (change the “LIST” or the “WHERE”?) so that a new dataview query would only extracts tasks from list sub-lists?

Thanks!

[gaufff]

For info, I’ve tried many queries using the dataview doc , but it feels like the richness of the “LIST” features won’t apply to “TASKS”.

Any help would be most welcome