Choice

Definition

AND

The two field-operator-value combinations, or two groupings, or one operator and one group, will be joined by a logical AND.  No grouping will occur and each evaluation will be performed at top level, from left to right.  These are evaluated last, after any groupings (as defined below).

OR

The two field-operator-value combinations, or two groupings, or one operator and one group, will be joined by a logical OR.  No grouping will occur and each evaluation will be performed at top level, from left to right.  These are evaluated last, after any groupings (as defined below).

AND1st

The two field-operator-value combinations will be joined by a logical AND.  There can be any number of AND1st connectors selected.  All field-operator-value combinations joined by AND1st will be grouped together and evaluated first, before any other groupings and before the upper level ANDs or ORs.

OR1st

The two field-operator-value combinations will be joined by a logical OR.  There can be any number of OR1st connectors selected.  All field-operator-value combinations joined by OR1st will be grouped together and evaluated first, before any other groupings and before the upper level ANDs or ORs.

AND2nd

The two field-operator-value combinations will be joined by a logical AND.  The same logic applies as for AND1st, except this group will be evaluated second, after any AND1st or OR1st groupings.

OR2nd

The two field-operator-value combinations will be joined by a logical OR.  The same logic applies as for OR1st, except this group will be evaluated second, after any AND1st or OR1st groupings.

AND3rd

same as above except evaluated third.

OR3rd

same as above except evaluated third.

AND4th

same as above except evaluated fourth.

OR4th

same as above except evaluated fourth.