i

Please enable JavaScript to view this site.

Documentation 8.9

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 Circulos_img1 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 Circulos_img3 on their left.

Example: Items.Quantity

 

Functions

In the wizard they are displayed with Circulos_img2 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')

Send us your comments
Share on X Share on Linkedin Send by Email Print