4. Filter operators

koalyptus edited this page Nov 30, 2017 · 8 revisions

To perform advanced searches from text-box filters, you can use the following advanced operators:

Operator Description Type Example
< Match values lower than search term number <1412
<= Match values lower than or equal to search term number <=1412
> Match values greater than search term number >1412
>= Match values greater than or equal to search term number >=1412
= Exact match: match only the whole search term(s) string / number =Sydney
* Partial match of search term(s) (default operator) string / number *Syd
! Match data different from search term(s) string / number !Sydney
{ Match data starting with search term string / number {S
} Match data ending with search term string / number }y
|| Match data containing at least one of the search term(s) string / number Sydney || Adelaide
&& Match data containing all search terms string / number >4.3 && <25.3
[empty] Match empty data [empty]
[nonempty] Match data which is not empty [nonempty]
rgx: Use a regular expression to match data rgx:de$

Be wary of whitespace in expressions: >= 10/11/2012 is incorrect, >=10/11/2012 is correct.

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.