Expressions

Create filtered lists from arrays and handling arrays with SQL and

To return the minimum, maximum, or average value in an array.

Evaluate data to find a true or false result.

Compare values in data and use the value in a conditional logical expression, e.g., is an amount greater than 100.

Return a date and time in various formats, e.g., ISO 8601.

Navigate and access specific elements or properties within a data set, e.g., for filtering or searching.

Compare values or display data based on certain conditions and use logical statements, e.g., adding HTML variables in content or a multi-select as a functionParameter.



Used for query refinement.

String expressions have many uses, such as concatenating two strings to display multiple data records in one row, writing numbers as strings, or selecting only a few characters from the whole string.

Advanced expressions are helpful when you need to filter an array of records to display specific data and perform expression transformations over the data.