| Operator |
Description |
Type |
Example |
| < |
Values lower than search term are matched |
number |
<20 |
| <= |
Values lower than or equal to search term are matched |
number |
<=20 |
| > |
Values greater than search term are matched |
number |
>20 |
| >= |
Values greater than or equal to search term are matched |
number |
>=20 |
| = |
Exact match search: only the whole search term(s) is matched |
string / number |
=20 |
| * |
Data containing search term(s) is matched (default operator) |
string / number |
*04 |
| ! |
Data that doesn't contain search term(s) is matched |
string / number |
!04 |
| { |
Data starting with search term is matched |
string / number |
{2 |
| } |
Data ending with search term is matched |
string / number |
}6 |
| || |
Data containing at least one of the search terms is matched |
string / number |
0.032 || 0.040 |
| && |
Data containing search terms is matched |
string / number |
>10 && <20 |
| [empty] |
Empty data is matched |
|
[empty] |
| [nonempty] |
Data which is not empty is matched |
|
[nonempty] |
| rgx: |
A regular expression is used to match data |
|
rgx:de$ |
