...
Info |
---|
Filters is a very important concept in ConfiForms and is used in many places, basically it is the core of ConfiForms, a base which helps to connect ConfiForms forms and allows to query data stored within ConfiForms form:
|
...
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 =
...