Understanding metadata filter operators
Starting with Web Service API 2.5, support on all filter operators on all field types is no longer supported.
In previous versions, it was possible to use each filter operator on all fields independent of the data type of the field. Although it is technically possible to use the operator like on a date, the result is not always predictable. Operator cilike means case insensitive like and only might be used on a text.
The following table indicates the filter operator that can be used on the data type of the fields. The first column of the table contains the filter operators, the following columns contain the different field data types.
| CARD | LOV | DATE | NUMBER | STING | LONG TEXT | |
|---|---|---|---|---|---|---|
equal | ||||||
not equal | ||||||
in | ||||||
not in | ||||||
like | ||||||
cilike | ||||||
greater than | ||||||
less than | ||||||
greater than or equal | ||||||
less than or equal | ||||||
between | ||||||
empty | ||||||
not empty |