i
Elements Used in the Wizard
The steps can be composed by different types of elements, separated by a ".".
•Form field
Form fields are used identifying them by the property Name. In the wizard they are displayed with in their left.
•Iterative containers
The property Name of the container is shown. Whenever an iterative container is used, then the field separated by a "." must be indicated. In the wizard they are displayed with in their left.
Example: Items.Number
•Functions
In the wizard they are displayed with in their left.
In every case it is indicated on the right, the data type they represent and in the case of the functions, the data type they receive as a parameter.
In case of a syntax error, a message is displayed indicating the problem.
Wizard Functions
These functions are displayed in the wizard, for each of them it is indicated a brief description of its functionality and in which steps of the wizard it is suggested.
Function |
Description |
Wizard (Step) |
Return Type |
---|---|---|---|
count(field) |
Counts the occurrences of a certain field. |
Series and group |
Numeric |
description(field) |
Returns the field description. |
Series |
Text |
max(field) |
Returns the maximum value. |
Series and group |
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 group |
Field type used |
average(field) |
Returns the average value. |
Series and group |
Numeric |
sum(field) |
Sums the values entered from the field. |
Series and group |
Numeric Decimal |
equal(field, field or value) |
Compares by equality the first field with the other field or value. |
Display criteria |
Boolean |
different(field, field or value) |
Compares by inequality the first field with the other field or value. |
Display criteria |
Boolean |
contains(field, value) |
Checks if the field contains a determined value. |
Display criteria |
Boolean |
startsWith(field, value) |
Checks if the field starts with a determined value. |
Display criteria |
Boolean |
doesNotStartWith(field, value) |
Checks if the field does NOT start with a determined value. |
Display criteria |
Boolean |
greater(field, field or value) |
Checks if the first field is greater than the second field or value entered. |
Display criteria |
Boolean |
greaterEqual(field, field or value) |
Checks if the first field is greater than or equal to the second field or value entered. |
Display criteria |
Boolean |
lower(field, field or value) |
Checks if the first field is lower than the second field or value entered. |
Display criteria |
Boolean |
lowerEqual(field, field or value) |
Checks if the first field is lower than or equal to the second field or value entered. |
Display criteria |
Boolean |
included(field, value1, value2, …) |
Checks if the field value exists in the value list separated by a comma. |
Display criteria |
Boolean |
notIncluded(field, value1, value2, …) |
Checks if the field value does not exists in the value list separated by a comma. |
Display criteria |
Boolean |