Limit the number of groups in a sort

[doncip]

I am trying to collect my not done tasks in the vault, by sorting them by folder and file name.
In fact, I have a folder for any project I am working on and inside these folders I have many notes which are the log of my activity on the projects. Every time I make new progress I duplicate the last note, with all the done and not done tasks in it, and I write new tasks and make some of them as done.
I wrote the following script:

```tasks
filename does not include obiettivi
path includes Progetti
sort by path
not done
group by folder
group by filename reverse

but this lists all the files in each folder. I want to have a list of the tasks only from the most recent file, which is the first in the sorting by filename in each folder.
How can I limit the number files listed in each folder? In other words, how can I limit the number of items per group?

Thanks!

[claremacrae]

Sure

https://publish.obsidian.md/tasks/Queries/Limiting#Limit+number+of+tasks+in+each+group

limit groups 1

[doncip]

I knew about this feature, but this limits the number of tasks in each group, not the number of groups displayed.
Instead I want to have a list of all my folders and for each folder the tasks only from the first file in the list.

• Folder
  • File 1 <- Only the first file in each folder
    - Tasks
• Folder
  • File 1 <- Only the first file in each folder
    - Tasks
• ...

[claremacrae]

The example output really helps explain the request - thank you.

There is certainly no built-in way to do that.

Someone who is comfortable with the Obsidian API might be able to use filter by function to look up the task file's folder, and see if the task's file is the first file in its parent folder...

I no longer have time to offer to write custom filters as part of user support, though.