What I’m trying to do
Hi!
I’m trying to get a querry that gives me all pages that don’t have any tasks to do. That’s because I need to know wich project isn’t moving, so I can plan it.
Things I have tried
So i’ve tried this:
List
FROM #projects
WHERE status = "active"
WHERE length(file.tasks) = 0
But this of course only gives me the projects that doesn’t have tasks at all, so it excludes projects that contains tasks already done. I’ve tried to to filter by only by completed tasks (something like ‘WHERE length(file.tasks.completed) = 0’), but it also didn’t work.
I also tried to do something with DataviewJS, but couldn’t get anywhere. I couldn’t find anything similiar anywhere. I appreciate if anyone has any idea! Thanks!