Versions Compared


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

Table of Contents


Advanced Form Row Data Data Store is an extended version of the default Form Data List Data Store. It allows you to add in Filter Conditions in a guided and friendly manner.

Advanced Form Data Data Store Properties

Configure Advanced Form Data Data Store

Figure 1: Configure Advanced Form Data Data Store



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

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



Figure 2: Advanced > Filter

Filter Conditions

Filter Conditions

Join Type
  • And
  • Or

Field ID. (e.g. title)

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

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

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

Code Block
e.customProperties.title = 'Trip'

A hash variable is accepted here.

Code Block
e.customProperties.submitted_by = ''

Userview Key can be used as part of the condition.

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

Aggregate Query

Figure 3: Advanced > Aggregrate Query


Group By

Add grouping clause/function to the eventual data set. This can be used together with Aggregate Fields above.

In figure 3, the "amount" field will be summed up by "claimant", shown in per record row.

Aggregate Fields

This field will be displayed once any number of columns has been added into the Group By field.

The select field is to aggregate.

  • Count
  • Count Distinct
  • Sum
  • Min
  • Max
  • Avg

In the sample screenshot above, the "amount" field will be put into the "Sum" function, and "Count" will be applied to "title".

Having Conditions

This field will be displayed once any number of columns has been added into the Group By field.

The HAVING clause enables you to specify conditions that filter which group results appear in the final results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on groups created by the GROUP BY clause. Read more at

Expression Columns

Figure 5: Advanced > Expression Columns