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.

Create validation for text fields by combining JSONata and Regex expressions.