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.

[quant]

Originally posted by Quantum7

and the lineage contains "*/Active/*"
works no problem ... matches wildcard

[Quantum7]

With second condition I'm referring to:
that have zero tasks or appointments with "NextAction" = Yes and Completed = False

(first condition would be "all projects"; I should have made that clearer though!)

[quant]

Originally posted by Quantum7
With second condition I'm referring to:
that have zero tasks or appointments with "NextAction" = Yes and Completed = False

(first condition would be "all projects"; I should have made that clearer though!)
so what is the problem exactly? Are you indenting "and" "or" properly?

http://www.kinook.com/Forum/showthread.php?s=&threadid=2536

[janrif]

Excuse me but what is 'NextAction'? Is that just a word you are just using as I don't find a reference to an attribute w that name. Or am I missing it? Thanks.

[PureMoxie]

Jan, sounds like it is just an attribute that he created. There is no default attribute by that name.

[Quantum7]

NextAction is indeed an attribute I created (GTD related). Yes/No checkbox in case you want to reproduce ;).

Hmmmm, this is a slightly simplified version of my problem:
I want the search to return all the projects that have at least one task as child that hasn't got a "Completed" flag yet.

The basic problem I'm having here seems to be:
- I'm already searching for projects and I don't have a way in which to specify a condition which applies to it's childs.

In more technical terms: I'd probably need to do a query within a query, which doesn't seem possible with the current advanced search.

Note:
I did succeed in making a search which returns all the projects that have no children as there's a specific "HasChildren" derived attribute available.

[quant]

ok, got it now!

No, it is not possible to create search-in-a-search. This is why I asked some time ago if UR could allow user to create own sql queries ...

but for the time being, ... being able to search in parents and children attributes would be sufficient, I think

[Quantum7]

Indeed. That'd be nice.

Maybe in a way in which the user can specify child.attribute name. Otherwise the attribute list would get extremely cluttered.
--> Not very likely to happen

Workaround (for those interested & technically adept):
http://www.kinook.com/Forum/showthread.php?s=&threadid=2825

[Quantum7]

Quant:
I can't seem to find a suggestion thread related to creating your own SQL queries in UR? Is there one?

[janrif]

Originally posted by Quantum7
NextAction is indeed an attribute I created (GTD related). Yes/No checkbox in case you want to reproduce ;).

Hmmmm, this is a slightly simplified version of my problem:
I want the search to return all the projects that have at least one task as child that hasn't got a "Completed" flag yet. [snip]

You've probably tried this but maybe it's a matter of proper nesting via indentation such as:

search project name = "XYZ"
and has children = yes
..and completed does not exst

I haven't tried this. ??

[quant]

Originally posted by Quantum7
Quant:
I can't seem to find a suggestion thread related to creating your own SQL queries in UR? Is there one?
http://www.kinook.com/Forum/showthread.php?s=&threadid=3113

[Quantum7]

Thanks. I created a new thread about that.