The criteria editor is included in several different areas of the user interface. It allows defining table filters, as well as validation and computation rules on data. This editor is based on the XPath 1.0 W3C Recommendation.
Two types of criteria exist: atomic criteria and conditional blocks.
Conditional blocks are made up of atomic criteria and other conditional blocks. They express a condition based on the criteria. The following types of blocks exist:
No criteria match: None of the criteria in the block match.
Not all criteria match: At least one criterion in the block does not match.
All criteria match: All criteria in the block match.
At least one criterion matches: One or more of the criteria match.
An atomic predicate is defined by a field, an operator, and an expression (either a value or an XPath formula).
Field | Specifies the field of the table to which the criterion applies. |
Operator | Specifies the operator used. Available operators depend on the data type of the field. |
Value | Specifies the value or expression. See Expression below. |
Code only | If checked, specifies searching the underlying values for the field instead of labels, which are searched by default. |
The expression can either be a fixed value or a formula. When creating a filter, only fixed values are authorized. During creation of a validation or computation rule, a formula can be created using the wizard.
Known limitation: The formula field does not validate input values, only the syntax and path are checked.