List functions

Tip

Since Process2024.1.0, a key/value list can be displayed by :

  • sysname.keys : returns the selected keys of the list field
  • sysname.values : returns the selected values of the list field
  • sysname : if there is a drop-down list on the sub-form it returns the value, otherwise it returns the key.

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

@UNION(objects...)

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).

@UNION(Validators.values.Managers;Validators.values.Assistants)

Exemple 2 : union of several strings or collection of strings

@UNION(TextField1;TextField2;TextCollectionField1;TextCollectionField2)

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

@INTERSECTION(objects...)

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).

@INTERSECTION(Validators.values.Managers;Validators.values.Assistants)

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

@LISTTOTEXT(SystemName;"separator")

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

@LISTTOTEXT(table.values.mails;";")