List of comparers

Query comparers or operators differ according to the data type of the field. The following table lists the supported operators for each data type. You can use either the name or the code in your JSON request body.

IsEmpty* and IsNotEmpty* are available when the field is nullable.

Operator	Code	String	Integer	Decimal	DateTime	Enum	Guid	Boolean
Is	0	+	+	+	+	+	+
IsNot	1	+	+	+	+	+	+
Contains	2	+
DoesNotContain	3	+
StartsWith	4	+
DoesNotStartWith	5	+
EndsWith	6	+
DoesNotEndWith	7	+
IsGreaterThan	8		+	+
IsGreaterThanOrEqualTo	9		+	+
IsLessThan	10		+	+
IsLessThanOrEqualTo	11		+	+
IsBefore	12				+
IsAfter	13				+
IsEmpty*	14	+	+	+	+	+	+	+
IsNotEmpty*	15	+	+	+	+	+	+	+
IsTrue	16							+
IsFalse	17							+
IsBetween	24		+	+	+
IsNotBetween	25		+	+	+

If you have suggestions for improving this article, let us know!