i
Elements Used in the Wizard
Steps can be composed of different types of elements, separated by a ".".
•Form fields
The form fields are used by identifying them through the property Name . In the wizard they are displayed with on their left.
•Iterative containers
The container Name property is shown. Whenever an iterative container is used, indicate the field separated by a ".". In the wizard they are displayed with on their left.
Example: Items.Quantity
•Functions
In the wizard they are displayed with on their left.
In all cases, the data type they represent is indicated on the right, and in the case of functions, the data type they receive as a parameter is shown.
In the event of a syntax error, a message indicating the problem is displayed.
Functions in the Wizard
These functions are displayed in the wizard, with a brief description of each function and suggested steps in the wizard.
Function |
Description |
Wizard (Step) |
Return Type |
---|---|---|---|
count(field) |
Counts the occurrences of a given field. |
Series and grouping |
Numeric |
description(field) |
Returns the description of the field. |
Series |
Text |
max(field) |
Returns the maximum value. |
Series and grouping |
Field type used |
month(field) |
Month of the year. It is used for date type fields. |
Series |
Numeric |
min(field) |
Returns the minimum value. |
Series and grouping |
Field type used |
average(field) |
Returns the average value. |
Series and grouping |
Numeric |
Add(field) |
Adds the entered field values. |
Series and grouping |
Numeric Decimal |
equals(field, field or value) |
Compares the first field with another field or value for equality. |
Display criteria |
Boolean |
distinct(field, field or value) |
Compares the first field with another field or value by inequality. |
Display criteria |
Boolean |
contains(field, value) |
Checks if the field contains a certain value. |
Display criteria |
Boolean |
startsWith(field,value) |
Checks if the field starts with a certain value. |
Display criteria |
Boolean |
doesnotStartWith(field,value) |
Checks if the field does not start with a certain value. |
Display criteria |
Boolean |
greater(field, field or value) |
Checks if the first field is greater than the second field or entered value. |
Display criteria |
Boolean |
greaterEqual(field, field, or value) |
Checks if the first field is greater than or equal to the second field or entered value. |
Display criteria |
Boolean |
less(field, field or value) |
Checks if the first field is less than the second field or entered value. |
Display criteria |
Boolean |
lessEqual(field, field, or value) |
Checks if the first field is less than or equal to the second field or entered value. |
Display criteria |
Boolean |
included(field, value1, value2, ...) |
Checks if the field value exists in the comma-separated list of values. |
Display criteria |
Boolean |
notIncluded(field, value1, value2, ...) |
Checks if the field value does not exist in the comma-separated list of values. |
Display criteria |
Boolean |
Operands
To add a condition of the type “contains value” or “does not contain value” without specifying a specific value, the operands 'NOTNULL' and 'ISNULL' can be used, respectively.
Example: Evaluates whether the actualAuthorizationDate field contains no value, or whether it has a value assigned.
equals(actualAuthorizationDate, 'ISNULL')
equals(actualAuthorizationDate, 'NOTNULL')