Documentation Center

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.
CARDLOVDATENUMBERSTINGLONG 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