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`)
`matches`	String field matches a regular expression.
`imatches`	Like `matches` but case insensitive.
`cidr`	IP address field is within a CIDR range.
`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
Regex
`matches`			x
`imatches`			x
Network
`cidr`							x
Quantifiers
`ANY`									x
`ALL`									x