Functional description
Difficulty level:
How do I search in a field with textual values?
A general explanation of searching with a particular field type.
Columns in the filters have a fixed field type. The possibilities of the search differ per type.
Field type
Text.
Allowed operators
!= | >= | <= | > | < | = | NOT IN | IN | !~ | ~ | IS NOT | IS |
---|---|---|---|---|---|---|---|---|---|---|---|
YES | NO | NO | NO | NO | YES | YES | YES | YES | YES | YES | YES |
Example advanced
LASTNAME ~ Jan
Technical Name: LASTNAME