...
[empty] | To match empty values for particular field. Example: field1:[empty] - will match records where field1 is empty (does not have a value, but the form defines this field) | ||||||||||
[now] | Current time and date, useful with '<' and '>' for comparing with dates stored. Example: someDateField:<[now] - will match records where field 'someDateField' has value which is in the past compared to now (current time) | ||||||||||
[today] | Same as [now], but without time | ||||||||||
[tomorrow] | To compare against tomorrow's date. Also something like [today]+1 could be used instead | ||||||||||
[yesterday] | To compare against yesterday's date. Also something like [today]-1 could be used instead | ||||||||||
[dateyyyyMMdddateyyyyMMdd] | To compare against given date in the format: yyyyMMdd, example: [date20150130] to give a date as Jan 30 2015 | ||||||||||
[datetimeyyyyMMdd HH:mm] | To compare against given date with time in the format: yyyyMMdd HH:mm, example: [date20151231 12:13] to give a date as Dec 31 2015 12:13 | ||||||||||
[date timetoday hh:mm] | You can use a shortcut to "today" with given construction | ||||||||||
'<' and '>' (and '<=' and '>=') | Can be used together with date and datetime fields, as well as to compare values for numeric fields stored | ||||||||||
! | To reverse the filter condition. Example: !field1:[empty] - will find records that have 'field1' field filled | ||||||||||
| |||||||||||
hasChanged(fieldName)
| See explanation in Virtual functions
|
...