Understanding View Criteria Item Operators

When building view criteria filters for use in a web service call, the following table provides the list of valid values that you can provide as an operator in a view criteria item.

Notice that some operators are valid only for fields of certain data types. For example, for a field {Priority of type number, you can use the >= operator, but in contrast, for a view criteria item related to a ResolutionDate field of type Date, you would use the ONORAFTER operator.

View Criteria Item Operators (Case-Sensitive!)

Operator	Description	Valid for Field Types
=	Equals	Number, Text, Date
<>	Not equals	Number, Text, Date
ISBLANK	Is null (no view criteria item value required)	Number, Text, Date
ISNOTBLANK	Is not null (no view criteria item value required)	Number, Text, Date
LIKE	Like	Text
STARTSWITH	Starts with	Text
>	Greater than	Number, Text
AFTER	Date comes after	Date
>=	Greater than or equal to	Number, Text
ONORAFTER	Date is on or comes after	Date
<	Less than	Number, Text
BEFORE	Date comes before	Date
<=	Less than or equal to	Number, Text
ONORBEFORE	Date is on or comes before	Date
BETWEEN	Is between (two view criteria item values required)	Number, Text, Date
NOTBETWEEN	Is not between (two view criteria item values required)	Number, Text, Date