An additional column can be added in this expression column 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.