Lists
Actions that create, read, change, sort, filter and summarise lists.
The List folder of the Process Designer toolbox holds the actions that work on lists: simple lists of text, numbers or true/false values, and lists of data models (JSON objects). Lists are entered as JSON, for example [1,2,3] or ["a","b"]. Unless a page says otherwise, positions (indexes) start at 0.
Numeric
| Action | What it does |
|---|---|
| Sum | Adds up all the numbers of a list. |
| Max | Returns the largest number. |
| Min | Returns the smallest number. |
| Median | Returns the middle value. |
| Arithmetic Mean | Returns the average. |
Read and change a list
| Action | What it does |
|---|---|
| Add | Appends an element to the end of a list. |
| Remove | Removes the first occurrence of a value. |
| Contains | Returns true if the list contains a value. |
| Get Index | Returns the position of a value, or -1. |
| Get Element | Returns the element at a position. |
| Has Elements | Fails the step if the list is empty. |
| Length | Returns the number of elements. |
| Sublist | Returns a slice of the list. |
| First N Elements | Returns the first N elements, optionally sorted. |
| Last N Elements | Returns the last N elements, optionally sorted. |
| Concatenate | Joins two lists into one. |
| List To String | Converts a list to JSON text. |
Sort, filter and clean up
| Action | What it does |
|---|---|
| Sort | Sorts a simple list ascending or descending. |
| Sort Data Model | Sorts a list of data models by one or more fields. |
| Simple Filter | Filters a simple list with one rule. |
| Filter | Filters a list of data models with field rules. |
| DeDuplicate | Finds duplicates in a simple list. |
| Find Duplicates | Finds duplicate records in a list of data models. |
| Similarity Search | Finds the values most similar to a text. |