Search Filter Operators

Search filters operate on attributes in order to narrow your search results. Search criteria (predicates) are specified as <attribute> <op> <comparison>, e.g. dns_activity.activity_id = ALLOWED.

OperatorDescription
=Field equals <value>.
==Like =, but case insensitive.
!=Field does not equal <value>.
!==Like !=, but case insensitive.
~, containsString field contains <value>.
~~, icontainsLike ~ but case insensitive.
^=, startswithString field starts with <value>.
^==, istartswithLike ^= but case insensitive.
$=, endswithString field ends with <value>.
$==, iendswithLike $= but case insensitive.
inEnum field is one of <values>, where values is a comma-separated list.
iinCase insensitive in.
<, >, <=, >=Numeric field is less than, greater than, less than or equal to, or greater than or equal to <value>
emptyField is empty (ex: null or None)

Search Filter Operators by Attribute Data Type

OperatornumbertimestampstringbooleanenumhashIPJSONarrays
Equality
=, ==xxxxxxx
!=, !==xxxxxxx
in, iinxxxxxxx
Sorting
<xxx
<=xxx
>=xxx
>xxx
Emptiness
emptyxxxxxxxxx
Strings
^=, ^==x
$=,$==x
~, ~~x
Quantifiers
ANYx
ALLx