#1
|
|||
|
|||
Searching - All projects with no Next Action
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. Last edited by Quantum7; 11-08-2007 at 12:21 PM. |
#2
|
||||
|
||||
Re: Searching - All projects with no Next Action
Quote:
|
#3
|
|||
|
|||
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!) |
#4
|
||||
|
||||
Quote:
http://www.kinook.com/Forum/showthre...&threadid=2536 |
#5
|
|||
|
|||
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.
|
#6
|
|||
|
|||
Jan, sounds like it is just an attribute that he created. There is no default attribute by that name.
|
#7
|
|||
|
|||
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. |
#8
|
||||
|
||||
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 |
#9
|
|||
|
|||
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/showthre...&threadid=2825 |
#10
|
|||
|
|||
Quant:
I can't seem to find a suggestion thread related to creating your own SQL queries in UR? Is there one? |
#11
|
|||
|
|||
Quote:
search project name = "XYZ" and has children = yes ..and completed does not exst I haven't tried this. ?? |
#12
|
||||
|
||||
Quote:
|
#13
|
|||
|
|||
Thanks. I created a new thread about that.
|
|
|