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 |