Functional description
Difficulty level:
How do I search in a field with numerical 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
Numeric.
Allowed operators
| != | >= | <= | > | < | = | NOT IN | IN | !~ | ~ | IS NOT | IS |
|---|---|---|---|---|---|---|---|---|---|---|---|
| YES | YES | YES | YES | YES | YES | YES | YES | NO | NO | NO | NO |
Example advanced
BOOKING_ID in (1361,1362) OR BOOKING_ID > 1362
Technical Name: BOOKING_ID
