Query to return all tasks that contain a link to the current file or children mentioned beneath it

[sinewave]

Can anyone help craft a query to retrieve all uncompleted tasks that contain a link to the current file in the title of the task OR any tasks contained within a sub-list item containing the same link e.g.

• [[My Test File]] links to a project
  • do this task
  • and that task
  • here’s a regular line
    • one last task
• also remember to do this task for [[My Test File]]
  • some more text with no task
  • but a peer that is a task
    • and a child with another task
• last list of things to do remember to do this task
  • the only task I wouldn’t want to return because it doesn’t link to my test file
  • this is the actual last task [[My Test File]]

In the example above I'm trying to create a DV query in [[My Test File]] that contains a list of all the tasks above except for the one called out as it doesn’t directly contain a link my test file or is contained within an item that does.

[AB1908]

Does task where file.path = this.file.path and !completed work?

[sinewave]

Hi, thx for replying!

That doesn’t seem to work unfortunately - says no results found.

[AB1908]

I think I know what I did wrong. I'll test this out again later.

[AB1908]

Can you give me an example vault to test with? Sorry for the late reply.