Filters / Conditions

...

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 you match current record's field's value with a given value

fieldname:value

where fieldname itself could be an expression and value could be a reference to field values via [entry.field_name] notation

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 :

To match values against regular expressions please consider using "matches" function from Virtual functions

myfield.matches(^[a-zA-Z0-9]*$):true

Reserved words to use in expressions:

...