...
Invalid example: (f1:*success AND (f2:>[yesterday] OR (f3:accepted)). As ConfiForms does not support inner brackets in expressions (yet)
Reserved words to use in expressions:
| [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 |
| [dateyyyyMMdd] | To compare against given date in the format: yyyyMMdd, example: [date20150131] to give a date as Jan 31 2015 |
| '<' 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 |
...
| Records created today | created:[today] |
| Records created before today | created:<[today] |
| Records created yesterday | created:<[today]-1 |
| Records created yesterday (alternative to previous example) | created:<[yesterday] |
| Records owned by current user | ownedBy:this |
| Records created by current user | createdBy:this |
When you have autopage type of controlfield, that sets automatically the page where the record was registered youcreated. You might want to filter by that, having a ListView, CardView or TableView on it. Let's say the autopage field is named "apage" | apage:this |