| < |
Values lower than search term are matched |
number |
<1492 |
| <= |
Values lower than or equal to search term are matched |
number |
<=1492 |
| > |
Values greater than search term are matched |
number |
>1492 |
| >= |
Values greater than or equal to search term are matched |
number |
>=1492 |
| = |
Exact match search: only the whole search term(s) is matched |
string / number |
=Red |
| * |
Data containing search term(s) is matched (default operator) |
string / number |
*Re |
| ! |
Data that doesn't contain search term(s) is matched |
string / number |
!Red |
| { |
Data starting with search term is matched |
string / number |
{S |
| } |
Data ending with search term is matched |
string / number |
}y |
| || |
Data containing at least one of the search terms is matched |
string / number |
Red || Green |
| && |
Data containing search terms is matched |
string / number |
>4.3 && <25.3 |
| [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$ |