List functions
Since Process2024.1.0, a key/value list can be displayed by :
sysnameorsysname.keys: give the selected keys of the list fieldsysname.values: give the selected values of the list field
UNION / UNION
Since Process17.0.0
Description
This function allows to carry out union operations on sets of the same nature by excluding duplicates. Collections and lists are supported.
Syntax
|
|
The function contains the following arguments :
| Parameter | Description | Mandatory | Comment |
|---|---|---|---|
| objects… | Any object of any kind. | Yes | Example : String, User(s), Group(s), etc. |
The UNION function returns a list of objects of the same type.
Examples
Example 1 : union of persons from two columns of a dynamic table
The function can be placed on a field of type Users (multiple) or Role (multiple).
|
|
Exemple 2 : union of several strings or collection of strings
|
|
INTERSECTION / INTERSECTION
Since Process17.0.0
Description
This function allows you to perform intersection operations on sets of the same nature excluding duplicates. Collections and lists are supported.
Syntax
|
|
The function contains the following arguments :
| Parameter | Description | Mandatory | Comment |
|---|---|---|---|
| objects… | Any object of any kind. | Yes | Example : String, User(s), Group(s), etc. |
The INTERSECTION function returns a list of objects of the same nature if common elements have been found, otherwise an empty list.
Examples
Example 1 : intersection of people from two columns of the pivot table
The function can be placed on a field of type Users (multiple) or Role (multiple).
|
|
LISTTOTEXT / LISTEVERSTEXTE
Since Process17.0.0
Description
This function returns, separated by a ‘;’ or the supplied separator, the names of the :
- Selected from a multiple list
- From a dynamic table column
- From a data universe data
Syntaxe
|
|
The function contains the following arguments :
| Parameter | Description | Mandatory | Comment |
|---|---|---|---|
| SystemName | system name of a multiple list field (e.g. nameSystemeChampList) or the path of a data universe data (e.g. nameSystemeReservoir.values.nameSystemeChamp) or the path of a dynamic table column (e.g. nameSystemeTable.values.nameSystemeColumn) | Oui | |
| separator | Separator | No |
The LISTTOTEXT function returns a string containing the elements of the list separated by the separator.
Examples
Example 1 : get the mails of the column “mails” of the dynamic table “table” separated by semicolons
|
|