Advanced Search Help

[glenviewjeff]

I still struggle with the advanced search. I want to accomplish this:

(Lineage Matches *A OR Lineage Matches *B OR Context equals C) AND ( Begin Date <= 11/30/08 OR Begin Date !Exists )

I laid it out like this, but I apparently am making a mistake:

Lineage Matches *A
OR Lineage Matches *B
OR Context equals C
AND Begin Date <= 11/30/08
OR Begin Date !Exists

Thanks!
Jeff

[quant]

you need to indent the last two lines and it will work, just hit "right arrow" on the fourth and then also on the fifth line

Indenting will "create" those parentheresis and they will be connected by AND cause it's the first on that level, read about indenting in the help file.

[glenviewjeff]

Sorry, the forum post messed up the indenting. I actually did indent those two lines.

Strangely, I'm only getting matches for items where begin date doesn't exist, not the ones that match with dates <= 11/30/08. When I delete the final condition, "OR Begin Date !Exists", then I get the items with dates <= 11/30/08.

Any ideas?

Thanks!
Jeff

[glenviewjeff]

Update: I just fixed it, but strangely, I had to indent the final line two levels deep. What am I missing?

Thanks,
Jeff

[quant]

indenting the last line twice shouldn't make any difference cause you are just adding another set of parenthesis, so instead of
(Lineage Matches *A OR Lineage Matches *B OR Context equals C) AND ( Begin Date <= 11/30/08 OR Begin Date !Exists )

you get

(Lineage Matches *A OR Lineage Matches *B OR Context equals C) AND ( Begin Date <= 11/30/08 OR (Begin Date !Exists ))

which is the same. I tested it, it works here as expected. No idea ...