Kinook Software Forums

Kinook Software Forums (http://www.kinook.com/Forum/index.php)
-   [UR] Suggestions (http://www.kinook.com/Forum/forumdisplay.php?f=25)
-   -   Searching - All projects with no Next Action (http://www.kinook.com/Forum/showthread.php?t=3202)

Quantum7 11-08-2007 04:43 AM

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.

quant 11-08-2007 08:38 AM

Re: Searching - All projects with no Next Action
 
Quote:

Originally posted by Quantum7

and the lineage contains "*/Active/*"

works no problem ... matches wildcard

Quantum7 11-08-2007 12:16 PM

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 11-08-2007 12:38 PM

Quote:

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/showthre...&threadid=2536

janrif 11-08-2007 02:32 PM

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 11-08-2007 03:56 PM

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

Quantum7 11-08-2007 06:22 PM

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 11-08-2007 06:43 PM

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 11-08-2007 06:51 PM

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

Quantum7 11-08-2007 07:03 PM

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

janrif 11-08-2007 07:17 PM

Quote:

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 11-09-2007 03:26 AM

Quote:

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/showthre...&threadid=3113

Quantum7 11-09-2007 05:52 PM

Thanks. I created a new thread about that.


All times are GMT -5. The time now is 03:19 PM.


Copyright 1999-2019 Kinook Software, Inc.