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.

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.
 CARDLOVDATENUMBERSTRINGLONG TEXT
equalXXXXX 
not equalXX XX 
inXXXXX 
not inXX XX 
likeXX  X 
greater than  XX  
less than  XX  
greater than or equal  XX  
less than or equal  XX  
between  XX  
emptyXXXXXX
not emptyXXXXXX