...
[entry] IS '<value>'
: Returns items that contain the entry equalling<value>
. This operation supports the"*"
and"?"
wildcards.[entry] IS NOT '<value>'
: Returns items that do not contain the entry equalling<value>
. This operation supports the"*"
and"?"
wildcards.[entry] BEGINS WITH '<value>'
: Returns items that contain the entry starting with the<value>
substring.[entry] ENDS WITH '<value>'
: Returns items that contain the entry ending with the<value>
substring.[entry] CONTAINS '<value>'
: Returns items that contain the entry with the<value>
substring.[entry] DOES NOT CONTAIN '<value>':
Returns items that do not contain the entry with the <value> substring".[entry] CONTAINS ALL ('<value_1>', '<value_2>', [...])
: Returns items that contain the entry with all of the specified substrings.[entry] CONTAINS ANY ('<value_1>', '<value_2>', [...])
: Returns items that contain the entry with any of the specified substrings.[entry] IS IN ('<value_1>', '<value_2>', [...])
: Returns items that contain the entry equalling any of the specified values.[entry] IS NOT IN ('<value_1>', '<value_2>', [...])
: Returns items that do not contain the entry equalling any of the specified values.
...
[entity] IS TRUE
: Returns items that contain the entry equalling atrue
value.[entity] IS FALSE
: Returns items that contain the entry equalling afalse
value.
...