Is it possible to support embedded grouping for tasks?

[wenlzhang]

When having a large number of tasks, it would be very useful to be able to group tasks in an embedded manner. For instance, tasks can be grouped in the following level: Due date > Priority > File path. This way, one can see tasks more visually friendly.

Moreover, it would also be very useful to add separators when sorting tasks. For instance, below tasks with the priority 1, there can be a grey horizontal line that separates tasks with priority 2.

Based on the above, it may also be very useful to support embedded grouping and add separators for table queries.

[blacksmithgu]

My existing grouping implementation is bad, but this will be improving soon; I'll be changing GROUP BY to allow for actually nesting groups.

[wenlzhang]

It would also be very useful if header can be treated as a level of nesting groups, as it can be especially useful for files with many tasks. For instance, one can easily query and group uncompleted tasks (by header) within one file without losing structure and context.

The following discussions may be related:

• How to group tasks by File and then by Section? #720
• Tasks under a specific heading? #547

[blacksmithgu]

dv.taskList() now supports arbitrarily nested task groupings, as do task queries (though maybe it's worth doing a little bit more ergonomics to make nested grouping easier).

[kngautham]

mnvwvnm in Discord helped me with this code

TASK
FROM "Ideas" 
WHERE Ideas
GROUP BY join(list(file.name, Status), " - ") AS ABC
SORT ABC ASC 

where I am grouping all Tasks by file name first and then by Status(Inline key). It repeats the file name for each Status grouping.

Can you give me an example on how to use dv.tasklist() to do this or how to use Task queries?