You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Definition

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.

New Feature

This feature has been enhanced in Joget Workflow v6.

Figure 1: Advanced Form Data Binder Properties

NameDescription
FormSource form to retrieve data from.

Figure 2: Advanced Form Data Binder Properties - Filter

NameDescription
Filter Conditions

Filter Conditions

NameDescription
Join Type
  • And
  • Or
Field

Field ID. (e.g. title)

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.

Figure 3: Advanced Form Data Binder Properties - Advanced

NameDescription
Extra Conditions

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

Syntax Query

Start your filter name with e.customProperties. followed by the field id (i.e. title)

HQL is accepted

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

Sample
e.customProperties.title = 'Trip'

Hash variable is accepted here.

Sample
e.customProperties.submitted_by = '#currentUser.id#'

Userview Key can be used as part of the condition.

Sample
e.customProperties.category_id = '#userviewKey#'


  • No labels