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
.
Operator | Description |
---|---|
= | Field equals <value> . |
== | Like = , but case insensitive. |
!= | Field does not equal <value> . |
!== | Like != , but case insensitive. |
~ , contains | String field contains <value> . |
~~ , icontains | Like ~ but case insensitive. |
^= , startswith | String field starts with <value> . |
^== , istartswith | Like ^= but case insensitive. |
$= , endswith | String field ends with <value> . |
$== , iendswith | Like $= but case insensitive. |
in | Enum field is one of <values> , where values is a comma-separated list. |
iin | Case insensitive in . |
< , > , <= , >= | Numeric field is less than, greater than, less than or equal to, or greater than or equal to <value> |
empty | Field is empty (ex: null or None ) |
Search Filter Operators by Attribute Data Type
Operator | number | timestamp | string | boolean | enum | hash | IP | JSON | arrays |
---|---|---|---|---|---|---|---|---|---|
Equality | |||||||||
= , == | x | x | x | x | x | x | x | ||
!= , !== | x | x | x | x | x | x | x | ||
in , iin | x | x | x | x | x | x | x | ||
Sorting | |||||||||
< | x | x | x | ||||||
<= | x | x | x | ||||||
>= | x | x | x | ||||||
> | x | x | x | ||||||
Emptiness | |||||||||
empty | x | x | x | x | x | x | x | x | x |
Strings | |||||||||
^= , ^== | x | ||||||||
$= ,$== | x | ||||||||
~ , ~~ | x | ||||||||
Quantifiers | |||||||||
ANY | x | ||||||||
ALL | x |
Updated 3 days ago