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. The list may optionally be surrounded with parentheses (()). |
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) |
not | Negates the following filter (field not contains 'value' or not field contains 'value'). |
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 9 days ago