Operators used in filters
If you define a filter, you can use these operators to specify the conditions for the fields of the filtered records:
Operator | Description | Available for fields of datatype |
---|---|---|
is (exactly) | The value of the field is exactly equal to the specified value. You must specify a complete value. | String, Numeric, Date/UTC, Enumerate |
is not | The value of the field is unequal to the specified value. You must specify a complete value. | String, Numeric, Date/UTC, Enumerate |
starts with | The contents of the field start with the specified characters. | String |
does not start with | The contents of the field do not start with the specified characters. | String |
equals or after | The value of the field is the same as or greater than the specified value. You can specify part of a search string. | String |
equals or before | The value of the field is the same as or less than the specified value. You can specify part of a search string. | String |
is after | The value of the field is greater than the specified value. You can specify part of a search string. | String |
is before | The value of the field is lower than the specified value. You can specify part of a search string. | String |
contains | The contents of the field contain the specified characters. | String |
doesn't contain | The contents of the field do not contain the specified characters. | String |
in | The value of the field is equal to one of the specified values. You must specify one or more complete values, separated by commas. | String, Numeric, Enumerate |
not in | The value of the field is unequal to any of the specified values. You must specify one or more complete values, separated by commas. | String, Numeric, Enumerate |
is more than | The value of the field is greater than the specified value. | Numeric |
is less than | The value of the field is less than the specified value. | Numeric |
is at least | The value of the field is greater than or equal to the specified value. | Numeric |
is at most | The value of the field is less than or equal to the specified value. | Numeric |
after | The date and time stored in the field is after the specified date and time. | Date/UTC |
before | The date and time stored in the field is before the specified date and time. | Date/UTC |
on or after | The date and time stored in the field is equal to, or after, the specified date and time. | Date/UTC |
on or before | The date and time stored in the field is equal to, or before, the specified date and time. | Date/UTC |