Operator | Field type | ||
---|---|---|---|
String /Extended string | Date-time / Date fields | Time fields | |
contains | x | ||
ends with | x | ||
= | x | x | x |
> | x | x | x |
>= | x | x | x |
< | x | x | x |
<= | x | x | x |
does not contain or is empty | x | ||
does not end with or is empty | x | ||
<> or empty | x | x | x |
does not start with or is empty | x | ||
starts with | x | ||
between | X* |
* For Date-time / Date fields the between operator is a special case. The user will only be able to fill the date part of the field for both field types. The system then searches for all items from 00:00 hours on the first date field until 23:59:59 on the second date field. |