...
Figure 1: Advanced Form Data Binder Properties
| Name | Description |
|---|
| Form | Source form to retrieve data from. |
Figure 2: Advanced Form Data Binder Properties - Filter
| Name | Description |
|---|
| Filter Conditions | Filter Conditions | Name | Description |
|---|
| Join Type | | | Field | Field | | | Operator | | 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
| | Value | Filter value. | Value | |
|
Figure 3: Advanced Form Data Binder Properties - Advanced
| Name | Description |
|---|
| Extra Conditions | Additional condition(s) for filtering the data set. HQL is the expected here. | Info |
|---|
| Start your filter name with e.customProperties. followed by the field id (i.e. title)
Image Added |
| Info |
|---|
| You may even use operator such as "LIKE" to narrow down your data set. Image Added |
| Code Block |
|---|
| e.customProperties.title = 'Trip' |
Hash variable is accepted here. | Code Block |
|---|
| e.customProperties.submitted_by = '#currentUser.id#' |
Userview Key can be used as part of the condition. | Code Block |
|---|
| e.customProperties.category_id = '#userviewKey#' |
|