Versions Compared

Old Version 13

changes.mady.by.user Mohamed Elorbany

Saved on

compared with

New Version 14

changes.mady.by.user Andrew

Saved on

Key

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

...

NameDescription
FormSource form to retrieve data from.
Joins Form Data Table
NameDescription
Form Data Table NameTarget table to join with
FieldTarget table field to join with
Join Field IdParent field Id to join with



Info
titleSample

In the screenshot example in Figure 1, such configurations can be presented with the following SQL.

Code Block
languagesql
titleSample SQL
SELECT * FROM "Claim Entry" entry JOIN hr_expense_claim claim ON claim.id = entry.claim



...

NameDescription
Filter Conditions

Filter Conditions

NameDescription
Join Type
  • And
  • Or
Field

Field ID. (e.g. username)

Image Modified

Operator
  • Equal
  • Not Equal
  • Greater Than
  • Greater Than Or Equal
  • Less Than
  • Less Than Or Equal
  • Like
  • Not Like
  • In
  • Not In
  • Is True
  • Is False
  • Is Null
  • Is Not Null
ValueFilter value
Extra Conditions

Additional condition(s) for filtering the data set. HQL is expected here.

Info
titleSyntax Query
Start your filter name with e.customProperties. followed by the field id (i.e. username)
Info
titleHQL is accepted

You may even use an operator such as "LIKE" to narrow down your data set.

Code Block
titleSample
e.customProperties.title = 'Trip'

A hash variable is accepted here.

Code Block
titleSample
e.customProperties.submitted_by = '#currentUser.id#'

Userview Key can be used as part of the condition.

Code Block
languagesql
titleSample
e.customProperties.category_id = '#userviewKey#'

...

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.

...