5.4.7 Operators in Filter Expressions
Table Operators in filter expressions lists all operators which can be used in filter expressions.
Operator | Description | Example |
---|---|---|
== | Equal | VALUE == 100 |
<= | Less or equal | VALUE <= 100 |
>= | Greater or equal | VALUE >= 100 |
!= | Not equal | VALUE != 100 |
< | Less | VALUE < 100 |
> | Greater | VALUE > 100 |
~= | Contains, case-sensitive | TEXT ~= "abc" |
?= | Contains, case-insensitive | TEXT ?= "abc" |
*= | Contains, regular expression | TEXT *= "(abc)+" |
|| | Or | TEXT ~= "abc" || TEXT ~= "def" |
&& | And | TEXT ~= "abc" && TEXT ~= "def" |
() | Group | (TEXT ~= "abc" || TEXT ~= "def") && TEXT ~= "ghi" |
& | Escape | TEXT ~= "&"" |
%n | String parameter | TEXT ~= %1 |
%nd | Integer parameter | TEXT < %1d |
%nf | Float parameter | TEXT < %1f |
String value | TEXT ~= "abc" | |
Integer value | VALUE == -100 | |
Float value | VALUE == 100.0 | |
Mapped value | TYPE == Error | |
Null value | TYPE == NULL |
The operator precedence in filter expressions is the same as in the programming languages C++.