Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NameDescription
Expression Columns

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".

Code Block
titleExpression
CAST(price AS long)
Code Block
SUBSTRING(CAST(dateCreated as string),1,10)   // To extract the date from the datetime database column
Code Block
titleExpression
CAST(e.customProperties.sales_price AS long) - CAST(e.customProperties.price AS long)

Example 2 - Concatenate multiple columns into one.

Code Block
titleExpression
CONCAT(first_name, ' ', last_name)
Code Block
titleExpression
first_name ||' '|| last_name
Custom Checkbox/Radio Button Value

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

...