You can use the AND and OR operators with each of the properties to build a search expression. The AND operator returns results only when all of the values match. The OR operator returns results when one or more of the property values match.
If you want to search for more than one value for the same property, the property must be listed more than once for you to select the values. For example, you might have a multi-value property named Breeds. To search for Collie or Poodle, select criteria similar to this:
Breeds = Collie OR Breeds = Poodle
The search evaluates the property values in the order listed, one row at a time, and any property without a value is skipped. If you specified three or more properties, all of the properties that are ANDed are then evaluated first as a group. If an OR is used between two ANDed property groups, the results from the first ANDed group of properties are added to the second ANDed group of properties. For example, a search consisting of property A and property B or property C and property D is evaluated by first getting the results of property A and property B and then adding the results from evaluating property C and property D.
The following examples evaluate to different results.
Property 1 = Report OR Property 2 = OR Property 3 = AND Property 4 not = cat |
Evaluates to: Property 1 = Report OR Property 4 not= cat |
Property 1 = Report AND Property 2 = AND Property 3 = AND Property 4 not = cat |
Evaluates to: Property 1 = Report AND Property 4 not= cat |
After the property values are evaluated, the search options and content value are checked. You decide if you want to search on properties AND content or if you want to search on properties OR content.
You can use wildcard characters for string-based property values when using the starts with, ends with, and contains operators.