Kinook Software Forums

Go Back   Kinook Software Forums > Ultra Recall > [UR] Suggestions

Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
  #1  
Old 11-08-2007, 03:43 AM
Quantum7 Quantum7 is online now
Registered User
 
Join Date: 10-01-2007
Location: Netherlands
Posts: 71
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 11:21 AM.
Reply With Quote
  #2  
Old 11-08-2007, 07:38 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Re: Searching - All projects with no Next Action

Quote:
Originally posted by Quantum7

and the lineage contains "*/Active/*"
works no problem ... matches wildcard
Reply With Quote
  #3  
Old 11-08-2007, 11:16 AM
Quantum7 Quantum7 is online now
Registered User
 
Join Date: 10-01-2007
Location: Netherlands
Posts: 71
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!)
Reply With Quote
  #4  
Old 11-08-2007, 11:38 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
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
Reply With Quote
  #5  
Old 11-08-2007, 01:32 PM
janrif janrif is offline
Registered User
 
Join Date: 07-08-2005
Location: Ridgefield CT USA
Posts: 852
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.
Reply With Quote
  #6  
Old 11-08-2007, 02:56 PM
PureMoxie PureMoxie is online now
Registered User
 
Join Date: 11-21-2004
Posts: 74
Jan, sounds like it is just an attribute that he created. There is no default attribute by that name.
Reply With Quote
  #7  
Old 11-08-2007, 05:22 PM
Quantum7 Quantum7 is online now
Registered User
 
Join Date: 10-01-2007
Location: Netherlands
Posts: 71
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.
Reply With Quote
  #8  
Old 11-08-2007, 05:43 PM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
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
Reply With Quote
  #9  
Old 11-08-2007, 05:51 PM
Quantum7 Quantum7 is online now
Registered User
 
Join Date: 10-01-2007
Location: Netherlands
Posts: 71
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
Reply With Quote
  #10  
Old 11-08-2007, 06:03 PM
Quantum7 Quantum7 is online now
Registered User
 
Join Date: 10-01-2007
Location: Netherlands
Posts: 71
Quant:
I can't seem to find a suggestion thread related to creating your own SQL queries in UR? Is there one?
Reply With Quote
  #11  
Old 11-08-2007, 06:17 PM
janrif janrif is offline
Registered User
 
Join Date: 07-08-2005
Location: Ridgefield CT USA
Posts: 852
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. ??
Reply With Quote
  #12  
Old 11-09-2007, 02:26 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
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
Reply With Quote
  #13  
Old 11-09-2007, 04:52 PM
Quantum7 Quantum7 is online now
Registered User
 
Join Date: 10-01-2007
Location: Netherlands
Posts: 71
Thanks. I created a new thread about that.
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 08:15 AM.


Copyright 1999-2019 Kinook Software, Inc.