| | Operators used in filtersIf 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 |
| |