8 4. Filter operators

koalyptus edited this page 2017-11-30 21:27:12 +11:00

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.

Website | Examples | Es6 documentation