Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-08-2009, 08:20 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Odd Search Behavior-Date Completed

In the Search pane, using Advance >>, if "Date Completed" is used as a search criteria, only Task items can be shown.
Other Info Items such as Appointments can be attached with Date Complete attribute, but will never be shown up in the above scenario even the Date Complete condition is met.

Armstrong
Reply With Quote
  #2  
Old 01-08-2009, 10:03 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
That works ok here (see attached sample and screen shot).
Attached Files
File Type: zip test.zip (117.7 KB, 1615 views)
Reply With Quote
  #3  
Old 01-08-2009, 05:13 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Kinook,
Thanks for your help. Searching with Date Completed criteria, your sample shows 3 different types of Info Items, namely, Task, Appointment, Note/Text.
My test with Date Completed Greater than or equal to "10/1/2008" (Oct 1, 2008), indeed the result shows various types of Info Items.
Obviously my original post in respect of the odd behavior of Date Completed search criteria is wrong.
Obviously I didn't know how to set/manipulate the Date Completed criteria properly.

Objective: List all Info Items which meet the following conditions:
1. have reminder >= 0 minutes
2. Incomplete
3. Begin Date >= 2 weeks ago
4. Begin End <= 3 weeks later
In essence, I want to search all Incomplete Info Items.
See the attachment.
I'm unable to set it right.
Please help. Thanks.
Armstrong
Attached Images
 
Reply With Quote
  #4  
Old 01-08-2009, 05:35 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Alternative questions:
How to search Info Items meeting the following conditions:
"Date Completed" is empty AND "Begin Date" is not empty.

With reference to GTD's Someday/Maybe Items, some Appointments/Tasks won't be assigned with any Begin Date and End Date.
Reply With Quote
  #5  
Old 01-08-2009, 06:54 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
That looks right. See searches in attached sample.
Attached Files
File Type: zip test.zip (74.4 KB, 1624 views)
Reply With Quote
  #6  
Old 01-08-2009, 08:52 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Kinook,
Thanks for taking time to produce a sample URD.
At first glance, your and my Search Criteria are the same.
After numerous tests, I discover a nuance. That's, my original post was not completely wrong.

For all default non-Task templates/items, "Date Completed" is not included. Because it never exists, the Search result will never include Info Items other than Task items.

On the other hand, in your Test.urd, both "abc"Appointment and "123" note are manually appended with the "Date Completed" attribute. That explains why your Search criteria can successfully list all Info Items, but mime lists only Task items.

Kinook, please correct me if my observation is inaccurate. Thanks.
Reply With Quote
  #7  
Old 01-08-2009, 09:42 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
Add an 'or Date Completed not exists' clause to the search (see attached).
Attached Files
File Type: zip test.zip (74.5 KB, 1681 views)
Reply With Quote
  #8  
Old 01-08-2009, 10:35 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Kinook,
Thanks for your help.
Just one more question.
Referring to the following logical expression:
((Reminder >= 0 minutes AND Begin Date <= 2/6/2009 AND Begin Date>=12/19/2008) and (Date Completed = "")) OR (Date Completed NOT Exists)


Question:
If the Date Completed attribute doesn't exist (eg, Appointments), what would be the result of (Date Completed = "")?

Thanks.
Armstrong
Reply With Quote
  #9  
Old 01-08-2009, 10:55 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Kinook,
I have trouble to follow your logic.
First of all, yes, your logic succeed to list all incomplete Info Items.

Since Or expression is located at the bottom, for all for default non-Task items it'll be evaluated as TRUE, even though all criteria/expressions above fail. That's, all non-Task item will be listed even though they don't meeting the Begin Date range. In actually, your Search criteria work fine. But why? Can you explain the magic? Thank you.
Armstrong
Attached Images
 
Reply With Quote
  #10  
Old 01-08-2009, 11:27 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
I'm further confused by the indenting Search criteria.
The criterion shown screenshot will list nothing.
If the second row is indented, the Search Result will list all Info Items. What is the difference? They basically the same logical expressions and operator (OR). The only difference is the indentation. Please help. Thanks.
Armstrong
Attached Images
 
Reply With Quote
  #11  
Old 01-08-2009, 11:41 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
I'm further perplexed by the arcane wording in the manual.
Referring to http://www.kinook.com/UltraRecall/Ma...ngstarted.htm, it says, "The Relationship for the first Criteria Row in an indent level determines how the expression represented by that indent level is related to the rest of the search criteria."
What does it mean in English? Please help. Thanks.

Armstrong
Reply With Quote
  #12  
Old 01-08-2009, 11:54 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
The only possibility for your Search criteria grid to succeed is to be interpreted as the following logical expression:

(Reminder >= 0 minutes AND Begin Date <= 2/6/2009 AND Begin Date>=12/19/2008) AND (Date Completed = "" OR Date Completed NOT Exists)

By merely looking up the Search criteria grid in your test.urd, it seems to present the following logical expression:

((Reminder >= 0 minutes AND Begin Date <= 2/6/2009 AND Begin Date>=12/19/2008) AND Date ) OR (Completed = "" OR Date Completed NOT Exists)

What went wrong with my interpretation? Please help. Thanks.

Armstrong
Reply With Quote
  #13  
Old 01-09-2009, 08:50 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
Quote:
Question:
If the Date Completed attribute doesn't exist (eg, Appointments), what would be the result of (Date Completed = "")?
Date Completed equals <null> only matches items containing a Date Completed attribute whose value is null (unchecked).
Reply With Quote
  #14  
Old 01-09-2009, 08:59 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
Quote:
Originally posted by armsys
I'm further confused by the indenting Search criteria.
The criterion shown screenshot will list nothing.
If the second row is indented, the Search Result will list all Info Items. What is the difference? They basically the same logical expressions and operator (OR). The only difference is the indentation. Please help. Thanks.
Armstrong
It seems that an extra indent is needed for the 'or' to function properly. Not sure why, but it is on our list to investigate.
Reply With Quote
  #15  
Old 01-09-2009, 09:02 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
Quote:
Originally posted by armsys
it says, "The Relationship for the first Criteria Row in an indent level determines how the expression represented by that indent level is related to the rest of the search criteria."
What does it mean in English? Please help. Thanks.
That an indent acts like an opening parenthesis.
Reply With Quote
Reply


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 10:02 PM.


Copyright © 1999-2023 Kinook Software, Inc.