Bases filter tasks for subprojects

First, search the help docs and this forum. Maybe your question has been answered! The debugging steps can help, too. Still stuck? Delete this line and proceed.

What I’m trying to do

In bases, I want to display the all tasks from a project and its related subprojects (child notes).

If the main project is house remodel, I’d like all task related to the kitchen project, bathroom project, and bedroom project to show up when I click on the remodel project.

The tasks are each a note. They have a properties of ‘note-type: “[[Task]]”’ and ‘projects: “[[house remodel]]”’

All projects are made from the same template. The subprojects would have the ‘parent: “[[house remodel]]”’. They all have ‘note-type: “[[Project]]”’ I don’t currently have a child property filled in on the main project, but I can if that would help.

Things I have tried

Using property filters for note-type: task and the file.hasLink(this.file) formula, I can get all the task for the current project. Tried adding file.hasProperty(projects: link(this.file))but they just gave an error. I also think that would just look at that link in the task, which isn’t helpful.

I don’t know how to filter for all the task that are also in the subprojects.

I did only skim your post, but this is no correct syntax. You could try something like file.properties.projects.contains(link(this.file).