Filtering Criteria in the Row Filter Handler
A list of possible conditions and data types to which they can be applied.
Condition | Integer | Real | String | Date/time | Logical | Variant |
---|---|---|---|---|---|---|
<, <=, >, >=, =, <> | • | • | • | • | • | |
null | • | • | • | • | • | • |
not null | • | • | • | • | • | • |
within the range | • | • | • | • | • | |
out of the range | • | • | • | • | • | |
listed | • | • | • | • | • | |
not listed | • | • | • | • | • | |
contains | • | • | ||||
does not contain | • | • | ||||
starting with | • | • | ||||
not starting with | • | • | ||||
ending with | • | • | ||||
not ending with | • | • | ||||
first | • | • | ||||
not first | • | • | ||||
last | • | • | ||||
not last | • | • | ||||
true | • | • | ||||
false | • | • |