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
Date.
Specific
For a date, the format is a sensitive subject.
It is wise to use the format YYYY-MM-DD when searching, for example 2019-10-03, which is equal to March 3, 2019.
Other formats also work, but there is a risk that day and month are used interchangeably.
In addition to a specific date, the relative date search is very powerful.
Relative searching is always relative to the NOW. A search term that is executed today and tomorrow, the execution moment therefore becomes important.
Relative search is done by specifying a number + type. "7d" stands for 7 days and "-2w" stands for 2 weeks ago.
Available types: d=days, w=weeks, h=hours, m=minutes.
Types may be combined. "7d5h" stands for 7 days + 5 hours.
Negative value: here the timeline is bent to the past.
Allowed operators
| != | >= | <= | > | < | = | NOT IN | IN | !~ | ~ | IS NOT | IS |
|---|---|---|---|---|---|---|---|---|---|---|---|
| YES | YES | YES | YES | YES | YES | YES | YES | NO | NO | NO | NO |
Example advanced
RES_FROMDATE > "-7d" OR EVENT_DATE < "04-01-2022"
