Kinook Software Forums

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

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 04-19-2007, 08:44 AM
janrif janrif is offline
Registered User
 
Join Date: 07-08-2005
Location: Ridgefield CT USA
Posts: 852
another puzzle

Sorry to hog the board w my stuff but here goes:

Advanced Search:
(category = waiting and flag does not = completed) or (flag = blue flag and Template ItemID does not = xxxx)

xxxx = one item w a blue flag

|---------------------------[ Start ] -------------------------|

This produces results that includes the one item w ItemID xxxx that includes a blue flag

I also indented the ItemID. The result was the same.

|--------------------------- [ End ] --------------------------|

I solved this by replacing ItemID with

Template Item does not equal Search

|--------------------------- [ End ] --------------------------|

With this change, UR cleaned up the results but I don't understand the problem with the first grouping.

Last edited by janrif; 04-19-2007 at 11:17 AM.
Reply With Quote
  #2  
Old 04-19-2007, 09:08 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
definitely indenting problem ...

first of all, put the parenthesis somewhere in your search so that we know what you are trying to achieve ...
Reply With Quote
  #3  
Old 04-19-2007, 10:18 AM
janrif janrif is offline
Registered User
 
Join Date: 07-08-2005
Location: Ridgefield CT USA
Posts: 852
Quote:
Originally posted by quant
definitely indenting problem ...

first of all, put the parenthesis somewhere in your search so that we know what you are trying to achieve ...
Sorry don't know what you mean. All search criteria were at top level or I would have indented.
Reply With Quote
  #4  
Old 04-19-2007, 10:40 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
what do you want?

(category = waiting AND flag does not = completed) OR ( flag = blue flag AND Template ItemID does not = xxxx)

or do you want

category = waiting AND (flag does not = completed OR flag= blue flag) AND Template ItemID does not = xxxx


???
Reply With Quote
  #5  
Old 04-19-2007, 11:19 AM
janrif janrif is offline
Registered User
 
Join Date: 07-08-2005
Location: Ridgefield CT USA
Posts: 852
Quote:
Originally posted by quant
what do you want?
See original msg edited w format you've requested.....I think.
Reply With Quote
  #6  
Old 04-19-2007, 11:23 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
ok, then do ...

category = waiting
and flag does not = completed[indent] or flag = blue flag [indent] and Template ItemID does not = xxxx
Reply With Quote
  #7  
Old 04-19-2007, 12:45 PM
janrif janrif is offline
Registered User
 
Join Date: 07-08-2005
Location: Ridgefield CT USA
Posts: 852
Quote:
Originally posted by quant
ok, then do ...

category = waiting
and flag does not = completed[indent] or flag = blue flag [indent] and Template ItemID does not = xxxx
This doesn't work as it still produces the item w the ItemID. See attached zip to see "Flag = waiting" in search results.
Attached Files
File Type: zip search_dump.zip (73.9 KB, 483 views)
Reply With Quote
  #8  
Old 04-19-2007, 01:12 PM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Quote:
Originally posted by janrif
This doesn't work as it still produces the item w the ItemID. See attached zip to see "Flag = waiting" in search results.
the search dump is non-conclusive cause I dont see ItemID in the search pane.

The "flag=waiting" is included in the results cause it has purple flag and its itemID is most probably not equal to 31389.
Reply With Quote
  #9  
Old 04-19-2007, 02:05 PM
janrif janrif is offline
Registered User
 
Join Date: 07-08-2005
Location: Ridgefield CT USA
Posts: 852
Quote:
Originally posted by quant
the search dump is non-conclusive cause I dont see ItemID in the search pane.

The "flag=waiting" is included in the results cause it has purple flag and its itemID is most probably not equal to 31389.
OK
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 12:58 PM.


Copyright 1999-2019 Kinook Software, Inc.