Filter Operators for Segments
The operator you select when creating filters greatly impacts the data that is returned, so it is important to understand the functionality of each operator.
| Operator | Description |
|---|---|
equals |
The expression matches the value exactly (including case). |
not equals (exclude No Value) |
The expression does not match the value exactly (including case), and does not contain a null value. |
less than |
The expression is less than the value. |
less than or equals |
The expression is less than or equal to the value. |
greater than |
The expression is greater than the value. |
greater than or equals |
The expression is greater than or equal to the value. |
between |
The expression is between two specified values. The between operator is available to use with date, currency, and numeric (integer and float) expressions. When using this operator with a date expression, records matching the date and time of the beginning value are returned, but those matching the date and time of the ending value are not. This prevents records from displaying twice on a report that is run once to view records created between 9:00 AM and 10:00 AM, and run again to view records created between 10:00 AM and 11:00 AM, for example. |
like |
The expression matches any part of the value.
When using this operator, you should use the % wildcard symbol to
offset your value. For example, to include values containing “all,”
type |
not like |
The expression does not match any part of
the value. The % character may be used as a wildcard. For example,
to exclude values containing “all,” type |
in list |
The expression values you want to search for are specified by selecting check boxes in a menu. The selected options display in a separate Selected Items list to assist you when selecting from menus with a large number of options. When using this operator with integer fields, the numbers in the
Value field must be comma-separated. When using this operator with
text fields, the text strings in the Value field must be comma-separated
and each text string must be offset by single quotes. For example, |
not in list |
The expression values you do not want to search for are specified by selecting check boxes in a menu. The selected options display in a separate Selected Items list to assist you when selecting from menus with a large number of options. This operator is available only with menu field expressions. When
using this operator with integer fields, the numbers in the Value
field must be comma-separated. When using this operator with text
fields, the text strings in the Value field must be comma-separated
and each text string must be offset by single quotes. For example, |
is null |
The expression contains a null value. |
is not null |
The expression does not contain a null value. |
not equals (include No Value) |
The expression does not match the value exactly (including case), or contains a null value. |
not like or null |
The expression does not match any part of the value, or contains a null value. |
Complex Expression |
The expression matches any part of the value. This operator allows wildcard searching using an asterisk (*) at the end of a word or partial word and a tilde (~) before a word to perform a similar phrases search on that word only. See Special Characters Allowed When Searching. |
Not Complex Expression |
The expression does not match the complex expression in the value. The Not Complex Expression operator is available only with text field expressions. |