...
| Field name constant | How to use | Details |
|---|---|---|
_count | _[count]:<3 | Will check for records count in the resultset and will return an empty result if this condition is not met. Important: this works better when you add this condition as last one, meaning that other filters were already applied on the dataset and you need to check the count of that filtered result |
_today | _[today]:>[date20151210] | For queries to run on a certain date (when date given is a constant). Will check today's date against the given date. In this example: the query will match when todays date is AFTER the 10 Dec 2015 |
_now | _[now]:<[datetime20151210 2:30] | When "now" (current time/date) is before the given date/time |
_user | [_user]:someusername ![_user]:someusername | Brings the user context into query execution. Available from ConfiForms version 1.17+ Anonymous users are evaluated as "" |
All fields support >, <, <=, >= and =
| Warning |
|---|
Since version 1.24.x of ConfiForms we had to change the constants for "field names" in filters from |
| Info |
|---|
Some field types (ConfiForms Field Definition), such as user types and page types could use "this" to reference to current user or current page (where the filter is used). See below |
...