...
ConfiForms plugin uses 'Lucene like' syntax for expressions, supports grouping using parenthesis and AND/OR logical operators. Nesting expressions is possible
Supports filtering for expressions that start with a wild-card. Supports filtering per field as well as free text search (filter to match against any field value).
Operators AND and OR are case-sensitive! (as everything else in ConfiForms: field names, form names, virtual functions)
Supports not notation, to filter records that do not match the given filter: '!' is used for that. Example: !f1:[empty] - will look for records where f1 field value is not empty (→ has some value)
Supports simple math operations and comparisons on dates (to add or substract days from today's date). See examples below
Valid example: (f1:*success AND f2:>[yesterday]) OR (f3:accepted) - matches records with field values having 'success' and where f2 field value is after yesterday or where f3 filed value is equals to 'accepted'
Valid example: (f1:*success AND f2:>[today]-1) OR (!f3:[empty]) - matches records with field values having 'success' and where f2 field value is after yesterday or where f3 field value is not empty
Through "evaluateFormula" from Virtual functions you have access to Supported math operators, formulas and functions
Main principle is
| Code Block |
|---|
fieldname:value |
where fieldname itself could be an expression and value could be a reference to field values via [entry.field_name] notation
| Code Block |
|---|
fieldname.trunc(3):[entry.anotherfield.trunc(3)] |
Important to follow the concept of a field name followed by a value to check against separated with :
Reserved words to use in expressions:
...