View Single Post
  #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