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.

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.

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


???

See original msg edited w format you've requested.....I think.

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.

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