Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-23-2009, 08:12 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Indenting search criteria

Graphical user interface (GUI) of the Search Criteria construction is visually pleasing as long as no indenting rows (criteria) are applied. The benefits of the indenting rows, often than not, diminish and precipitate more confusion than clarity. The following simple complex indenting criteria (see the screen shot) may represent (Reminder >0 minutes AND Begin Date >=12/25/2008 AND Begin Date <= 1/30/2009) AND (Date Completed = NIL OR Date Completed doesn't exists). But I'm not sure.

Textual representation of the Search Criteria are more comprehensible, definitive, and flexible regardless of the complexity involved.

Just my two cents.

Armstrong
Reply With Quote
  #2  
Old 01-23-2009, 08:15 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
The screen shot for the above post.
Attached Images
 
Reply With Quote
  #3  
Old 01-23-2009, 08:20 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Could someone be very kind enough to interpret the following screen shot? What would be the logical meaning for the unindented last row?
Thanks a lot.
Armstrong
Attached Images
 
Reply With Quote
  #4  
Old 01-23-2009, 11:02 PM
ashwken ashwken is offline
Registered User
 
Join Date: 10-16-2005
Location: Blairsville, GA USA
Posts: 431
Quote:
Originally posted by armsys
Could someone be very kind enough to interpret the following screen shot? What would be the logical meaning for the unindented last row?
Thanks a lot.
Armstrong
Not sure if this is correct, but this is how I see the statement:

(
(Reminder > 0)
.AND.
(Begin Date >= 12/25/2008)
.AND.
(Begin Date <= 01/30/2009 .AND. Date Completed = NULL)
.OR.
(Date Completed .NOT. exists (NULL))
)
Reply With Quote
  #5  
Old 01-24-2009, 12:38 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Quote:
Originally posted by ashwken
Not sure if this is correct,...
That's exactly my main point, that's, Search Criteria GUI creates more confusion than clarity. Your interpretation doesn't match the result. Specifically, the .OR. (Date Completed .NOT. exists) expression alone could have shown all non-task Info Items. The result doesn't.

Neither do I know the interpretation for sure.

Therefore, it would benefit enormously all UR users by displaying the textual interpretation underneath the Search Criteria matrix (table).

Armstrong

Last edited by armsys; 01-24-2009 at 05:39 AM.
Reply With Quote
  #6  
Old 01-24-2009, 12:54 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
ashwken,
Thanks for your trying to help.
Armstrong
Reply With Quote
  #7  
Old 01-24-2009, 05:22 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Quote:
Originally posted by armsys
Therefore, it would benefit enormously all UR users by displaying the textual interpretation underneath the Search Criteria matrix (table).
I already requested this, but got no reply.

Anyway, if you didn't indent the last row the search would be (as far as I know):

you have two AND and one OR on the same level (the order on the same level does not matter, read in the help file "location does not matter"), by the help file AND takes precedence (all AND are evaluated before any OR, on the same level), so you have

(Reminder > 0 AND Begin Date >= 12/25/2008 AND Begin Date <= 01/30/2009)
OR
Date Completed .NOT. exists

Now you connect the above with AND on the second level, so you get


((Reminder > 0 AND Begin Date >= 12/25/2008 AND Begin Date <= 01/30/2009)
OR
Date Completed .NOT. exists)
AND
Date Completed = NULL
Reply With Quote
  #8  
Old 01-24-2009, 07:55 AM
ashwken ashwken is offline
Registered User
 
Join Date: 10-16-2005
Location: Blairsville, GA USA
Posts: 431
Quote:
Originally posted by quant
I already requested this, but got no reply.

Anyway, if you didn't indent the last row the search would be (as far as I know):

you have two AND and one OR on the same level (the order on the same level does not matter, read in the help file "location does not matter"), by the help file AND takes precedence (all AND are evaluated before any OR, on the same level), so you have

(Reminder > 0 AND Begin Date >= 12/25/2008 AND Begin Date <= 01/30/2009)
OR
Date Completed .NOT. exists

Now you connect the above with AND on the second level, so you get


((Reminder > 0 AND Begin Date >= 12/25/2008 AND Begin Date <= 01/30/2009)
OR
Date Completed .NOT. exists)
AND
Date Completed = NULL
So, the positioning of the indent(s) within the grid (which row they occupy) has no bearing on the evaulation sequence, except that the rows are evaluated by position within an indent level with .AND. taking precedence.

In the above example, the indented row could actually be the last row of the grid?
Reply With Quote
  #9  
Old 01-24-2009, 08:12 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Quote:
Originally posted by ashwken
In the above example, the indented row could actually be the last row of the grid?
yes, makes no difference.

"All Criteria Rows at the same indent level (regardless of location) will be evaluated together as if they were enclosed in a parenthesis (comprising a composite Search Expression). 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."
Reply With Quote
  #10  
Old 01-24-2009, 08:52 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Quote:
Originally posted by quant
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."
Quant, do you actually understand this cryptic sentence? It seems to be written in an alien language.

Nonetheless, Kinook illuminates it in http://www.kinook.com/Forum/showthre...threadid=3908. However, it doesn't diminish the cloud of confusion over the complex multi-indenting Search Criteria. I have to experiment with long hours until the search result matches my intent.

Armstrong

Last edited by armsys; 01-24-2009 at 09:08 AM.
Reply With Quote
  #11  
Old 01-24-2009, 09:19 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Quote:
Originally posted by quant
you have two AND and one OR on the same level (the order on the same level does not matter, read in the help file "location does not matter"), by the help file AND takes precedence (all AND are evaluated before any OR, on the same level), so you have...
Appreciate your illumination. Your theory suggesting that same level does not matter may contradict the priority formed by the presumed parentheses, that's, the indenting Search Criteria.

Therefore, for the same level, the location does matter.

Armstrong
Reply With Quote
  #12  
Old 01-24-2009, 12:25 PM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Quote:
Originally posted by armsys
Appreciate your illumination. Your theory suggesting that same level does not matter may contradict the priority formed by the presumed parentheses, that's, the indenting Search Criteria.

Therefore, for the same level, the location does matter.

Armstrong
I think it doesn't. Prove me wrong

Let's take for example the search I created, I provided my explanation what it does, with 2 examples that match it. Can you think of item that would match and contradict the search bellow?

((aaa AND iii) OR eee)
..AND
..(
....((bbb AND fff) OR jjj)
....OR
....(
......(ccc OR ggg)
......AND
........hhh
....)
..)
Attached Images
 
Reply With Quote
  #13  
Old 01-24-2009, 05:51 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Quote:
Originally posted by quant
I think it doesn't. Prove me wrong...
Quant,
I'm humbled by your efforts to vindicate your theory. In fact, you're the first one and the only one enlightening us that the same level can mean transcending across inconsecutive Search Criteria (rows). That's awesome.

I certainly have no intent to prove you wrong. My posts highlights the critical fact that the Search Criteria construction GUI causes more confusion rather than clarity. My view is based upon the UR Manual (http://www.kinook.com/UltraRecall/Ma...ingstarted.htm): "Sometimes this is not the desired search behaviour. You can explicitly specify precedence using Indenting, which
function like parentheses."

Obviously your sample Search prove it's not necessarily always the case.

On the contrary, your textual Search Criteria (logical expression) is crystal clear to everyone free of any confusion.

Hopefully the Search Criteria textual display will be implemented by Kinook in the near future.

Armstrong
Reply With Quote
  #14  
Old 01-25-2009, 06:06 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Quote:
Originally posted by armsys
... In fact, you're the first one and the only one enlightening us that the same level can mean transcending across inconsecutive Search Criteria (rows). That's awesome.
isn't it exactly what the help file says?

"All Criteria Rows at the same indent level (regardless of location) will be evaluated together as if they were enclosed in a parenthesis"

That means "transcending across inconsecutive rows" as well. Take whatever is on the same indent level and put it in the parenthesis. I tried one more very trivial example, ... again the results seems to be in line with how I understand the help file:
(aaa OR ccc) AND bbb

Surely, one would probably not make a confusing search criteria like the previous complicated example, and the rows with the same indent level would be consecutive.
Attached Images
 
Reply With Quote
  #15  
Old 01-25-2009, 06:22 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Quote:
Originally posted by armsys
"Sometimes this is not the desired search behaviour. You can explicitly specify precedence using Indenting, which
function like parentheses."
and the next line in the help file explains how the parenthesis are created ...
Quote:
Originally posted by armsys
Obviously your sample Search prove it's not necessarily always the case.
Again, the important part is how the parenthesis are created, this is where the confusion seems to arrise ...
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 11:00 AM.


Copyright © 1999-2023 Kinook Software, Inc.