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`		+	+	+

Do you have some feedback for us?

If you have suggestions for improving this article,