All or Any criteria in this set?

[Bruce Kieffer]

Please explain how this works to select Any or All a criteria item down in the criteria list? I've experimented a bit, and I cannot figure out how it works or what it does.

[Tom W.]

At the moment the worksheet will search for objects which are either the '#20 Biscuit' symbol or the 'Amazon Rose' symbol. If you changed line one to 'all criteria in this set' you'd be asking the worksheet to search for objects which are simultaneously the '#20 Biscuit' symbol and the 'Amazon Rose' symbol which clearly isn't going to return anything as an object can only be one symbol or another.

 

Is that what you meant?

 

So you might add to the criteria above + say 'search for either this symbol or that symbol [any criteria] on this layer + in this class [all criteria]'.

[Bruce Kieffer]

1 hour ago, Tom W. said:

So you might add to the criteria above + say 'search for either this symbol or that symbol [any criteria] on this layer + in this class [all criteria]'.

I'm referring to adding the any or all to item #3 How does that work?

[Tom W.]

11 minutes ago, Bruce Kieffer said:

I'm referring to adding the any or all to item #3 How does that work?

 

Just click on 'All criteria in this set' or 'Any criteria in this set':

[Bruce Kieffer]

But what is the result? What does that do to the entire criteria?

[Tom W.]

It just creates a new set. So like the example I gave earlier, if you wanted to search for the symbols called 'Symbol-1' + 'Symbol-2' but only where they are on 'Design Layer-1' + in 'Class Name 1' you would have this:

 

 

 

Sorry if I'm still barking up the wrong tree

[Bruce Kieffer]

44 minutes ago, Tom W. said:

It just creates a new set. So like the example I gave earlier, if you wanted to search for the symbols called 'Symbol-1' + 'Symbol-2' but only where they are on 'Design Layer-1' + in 'Class Name 1' you would have this:

 

 

 

Sorry if I'm still barking up the wrong tree

That's exactly what I'm looking to know. Now I need to mess around with it a bit. Thanks @Tom W.

[Bruce Kieffer]

Got it working. For me it's a lot of trial and error. At least I understand what it does now so maybe I can use it to my advantage in the future.

[Tom W.]

It's just a way of inserting 'and' (&) or 'or' (|) into the written criteria.

[Pat Stanford]

Each time you put in a new Any or All is creates a new sub-part to the criteria. That Subpart will either do a logical AND (ALL) where each item inside the sub-part has to exist, or a logical OR (ANY) where one or more of the criteria need to exist.

 

As Tom says, ALL is & and ANY is | when you look at the actual formula for the criteria.