...
Note |
---|
There is are only one way two ways to circumvent a table filter - : # by using the rawSQL plugin Therefore, if one wishes to maintain the effects of a filter, it is important to remember to modify such queries with an appropriate SQL WHERE clause .in case any of the above two cases apply |
= | Only records whose column equals the specified value |
< | Only records whose column is less than the specified value |
> | Only records whose column greater than the specified value |
>= | Only records whose column greater than or equals the specified value |
<= | Only records whose column less than or equalsthe specified value |
!= | Only records whose column does not equal the specified value |
^ | Only records whose column value is null |
LIKE | Only records whose column matches using the SQL LIKE construct (use wildcard '%' characters) |
IN | Only records whose column value is in (using the SQL IN construct) a list of values |
# | Modifier, used to make case-insensitive queries |
|| | Modifier used to concatenate two conditions w/ a logical OR |
Note |
---|
Operators and modifiers may be combined, producing more complex conditions. For example #^||!= would translate to: is null OR case-insensitive not equals |
...