Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [UR] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=23)
-   -   Odd Search Behavior-Date Completed (https://www.kinook.com/Forum/showthread.php?t=3908)

armsys 01-08-2009 07:20 AM

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

kinook 01-08-2009 09:03 AM

1 Attachment(s)
That works ok here (see attached sample and screen shot).

armsys 01-08-2009 04:13 PM

1 Attachment(s)
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

armsys 01-08-2009 04:35 PM

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.

kinook 01-08-2009 05:54 PM

1 Attachment(s)
That looks right. See searches in attached sample.

armsys 01-08-2009 07:52 PM

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.

kinook 01-08-2009 08:42 PM

1 Attachment(s)
Add an 'or Date Completed not exists' clause to the search (see attached).

armsys 01-08-2009 09:35 PM

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

armsys 01-08-2009 09:55 PM

1 Attachment(s)
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

armsys 01-08-2009 10:27 PM

1 Attachment(s)
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

armsys 01-08-2009 10:41 PM

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

armsys 01-08-2009 10:54 PM

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

kinook 01-09-2009 07:50 AM

Quote:

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

Date Completed equals only matches items containing a Date Completed attribute whose value is null (unchecked).

kinook 01-09-2009 07:59 AM

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.

kinook 01-09-2009 08:02 AM

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.


All times are GMT -5. The time now is 08:46 PM.


Copyright © 1999-2023 Kinook Software, Inc.