Versions Compared

Key

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

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

Figure 1: Advanced Form Data Binder Properties

NameDescription
Form Source form to retrieve data from.

Figure 2: Advanced Form Data Binder Properties - Filter

NameDescription
Filter Conditions

Filter Conditions

NameDescription
Join Type 
  • And
  • Or
Field 
Operator 

Field ID. (e.g. title)

Image Added

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

Figure 3: Advanced Form Data Binder Properties - Advanced

NameDescription
Extra Conditions

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

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

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

Image Added

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

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#'