Operators reference

Discover the available operators to write criterias in CQL.

Croct's mascot winking
Looking for something specific?

Use the search bar at the top of the page or press / to quickly search through the documentation.

Use the summary below to quickly jump to a specific topic:

PageDescription
Equal toLearn how to check if a property is equal a value.
Greater thanLearn how to check if a property is greater than a value.
Greater than or equalLearn how to check if a property is greater than or equal to a value.
Less thanLearn how to check if a property is less than a value.
Less than or equalLearn how to check if a property is less than or equal to a value.
Starting withLearn how to check if a string starts with a specific prefix.
Ending withLearn how to check if a string ends with a specific suffix.
LikeLearn how to check if a string matches another.
InLearn how to check if an element exists in a collection.
ContainingLearn how to check if a collection contains a specific element.
Containing allLearn how to check if a collection contains all elements of another.
Containing noneLearn how to check if a collection does not contain any element of another.
Containing eitherLearn how to check if a collection contains one or more elements.
Containing neitherLearn how to check if a collection has no intersection with another.