Compound search

With a compound search, you can combine two or more searches with search operators. This allows customized and specific filtering of data. A compound search is triggered by enclosing the search within a set of parentheses. You can use multiple search operators in a single compound search.

In its most basic form, a compound search can contain a single value. Unlike other search methods, a compound search for a single term will only return values that are an exact match with the search term. This can help you create more specific searches of your data.

A compound search can contain one or more wildcards. If search content contains spaces, use quotation marks to enclose the value as it appears within the compound search.

For more information about quotation marks and wildcards, see Text search.

OR search operator ("|")

Using the OR operator, the compound search will return values that match any of the included searches.

AND search operator ("&")

Using the AND operator, the compound search will return values that match all of the search items included in the statement. Since compound searches return exact matches only, this operator is typically only used with one or more wildcards.

This additional example uses the AND operator and multiple wildcards in a compound search.

XOR search operator ("^")

Using the XOR operator, the compound search will return values that match either the first or second search, but not both.

In the example below, the search returns values that either start with the letter "j'" or end with the letter "h", but values that match both these criteria (such as "Josh") are not included.

This example uses the XOR operator and multiple wildcards.