...
[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: [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 | ||||||||||
[datetimetoday 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
|
Some examples:
- field1:[today]-5 - assuming field1 is of type date (or datetime) this filter will return records where field1 value is not older than 5 days from now
- field1:[today]+10 - assuming field1 is of type date (or datetime) this filter will return records where field1 value is not after 10 days from now
...
Show all records | * | ||
Show records where text field called "mytext" starts with the value "this is test" | mytext:this is test* | ||
Show records where text field called "mytext" has the value "this is test" | mytext:*this is test* | ||
Show records where text field called "mytext" ends with the value "this is test" | mytext:*this is test | ||
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 |
Use instead: ownedBy:[entry._user] | ||
Records created by current user |
Use instead: createdBy:[entry._user] | ||
When you have autopage type of field, that sets automatically the page where the record was created. You might want to filter by that, having a ListView, CardView or TableView on it. Let's say the autopage field is named "apage" |
Use instead: apage.id:[entry._page.id] | ||
How to filter, if field type is Page or Autopage: use Confluence pageId numeric value in filters | somepagefield:pageId | ||
Assuming you have a field of type "Page" and the field is called "mypage". And you want to filter by page title. This is totally possible, as ConfiForms allows you to access rich properties easily. | mypage.title:Some title* See Accessing field values and properties for more details |
Info | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
See Accessing field values and properties to understand which properties and fields a field has. Any accessible field could be used in a filter, both on the left side of the expression and on the right side of the expression Examples:
|