Dataview: List of files that don't contain tasks

[_Dan]

What I’m trying to do

I use a tag of #Status/Waiting on both individual tasks and files that I’m waiting for an external action on.

Using dataview I can see a list of incomplete tasks with the tag:

TASK 
FROM #Status/Waiting 
WHERE !completed 

And a list of files that contain the tag:

LIST 
FROM #Status/Waiting 

I’d like to be able to have the second query just show a list of files with the waiting tag that don’t have any tasks in. In this was I could have two separate list of things I’m waiting on (i.e. things with the waiting tag): Tasks, and file (which might well be long-winded).

Is it possible to do this: i.e.

Use dataview to create a LIST of files that don’t contain any tasks?

[_Dan]

I think I can answer my own question. The following (I think) shows all files with the tag #Status/Waiting that don’t contain any tasks:

LIST 
FROM #Status/Waiting 
WHERE !file.tasks

[_Dan]

For completeness… potentially to my future self, here’s how I put count of all things with the waiting tag (both individual tasks and files) onto a page I use as a status page with a link to a file named Waiting on which the Dataview lives:

[[Waiting]] $=(dv.pages("#Status/Waiting").length)-dv.pages("#Status/Waiting").file.tasks.where(t => t.completed).length

i.e.
A count of all tasks and pages with the tag minus completed tasks with the tag.