Searching - All projects with no Next Action

[Quantum7]

I created an extra task and appointment attribute: "NextAction".

Now I want to search for all projects that have zero tasks or appointments with "NextAction" = Yes and Completed = False.
and the lineage matches wildcard "*/Active/*"

The second condition I'm having trouble with. I suspect it currently isn't possible to make a condition like that. Therefore I'm posting it in the Suggestions forum.

If anyone can suggest a solution (or can generalize this request) I'd definitely be interested.