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)

SUBSTRING(CAST(dateCreated as string),1,10)   // To extract the date from the datetime database column

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)

first_name ||' '|| last_name

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