Skip to content

Filter operators

The base filter operators used by typed filter models.

A base filter model that can be used to create more specific filter models.

PropertyTypeRequiredDescription
operatorEquivalenceOperators | ComparisonOperators | ArrayOperators | StringOperators | RangeOperators | AllOperatorsYesThe operator to apply to the filter value.
valueunknownYesThe value to use for the filter operation.
{
"operator": "eq",
"value": null
}

Operators that filter a field based on an exact match to a value.

ValueDescription
eqEqual to a value.
neqNot equal to a value.
"eq"

Operators that filter a field based on a comparison to a value.

ValueDescription
gtGreater than a value.
gteGreater than or equal to a value.
ltLess than a value.
lteLess than or equal to a value.
"gt"

Operators that filter a field based on an array of values.

ValueDescription
inField's value is one of the supplied values.
notInField's value is not in the supplied values.
"in"

Operators that filter a field based on a string value.

ValueDescription
likeField matches the supplied pattern (case-insensitive substring or wildcard).
notLikeField does not match the supplied pattern.
"like"

Operators that filter a field based on a range of values.

ValueDescription
betweenField's value falls within the supplied inclusive range.
outsideField's value falls outside the supplied range.
"between"

Union of every filter operator across equivalence, comparison, array, range, and string operators.

ValueDescription
eqEqual to a value.
neqNot equal to a value.
gtGreater than a value.
gteGreater than or equal to a value.
ltLess than a value.
lteLess than or equal to a value.
inField's value is one of the supplied values.
notInField's value is not in the supplied values.
betweenField's value falls within the supplied inclusive range.
outsideField's value falls outside the supplied range.
likeField matches the supplied pattern.
notLikeField does not match the supplied pattern.
"eq"