Page History

An additional column can be added in this expression columns using Hibernate Query Language (HQL). This is especially useful when you need to perform additional computation on multiple columns.

Example 1 - Cast column to data type "long".

CAST(price AS long)

CAST(e.customProperties.sales_price AS long) - CAST(e.customProperties.price AS long)

Example 2 - Concatenate multiple columns into one.

CONCAT(first_name, ' ', last_name)

Figure 5: Advanced > Expression Columns

Define custom record ID to be used to pass over to column action. Defaulted to ID.