...
| Panel |
|---|
| borderColor | red |
|---|
| borderWidth | 1 |
|---|
| titleBGColor | #ffcccc |
|---|
| borderStyle | solid |
|---|
| title | New Feature |
|---|
|
This feature has been enhanced in Joget Workflow v6. |
Image Removed
Image Added
Figure 1: Advanced Form Data Binder Properties
| Name | Description |
|---|
| Form | Source form to retrieve data from. |
| Joins Form Data Table | | Info |
|---|
| This is a new feature in Joget Workflow v6. |
| Name | Description |
|---|
| Form Data Table Name | Target table to join with | | Field | Target table field to join with | | Join Field Id | Parent field Id to join with |
| Info |
|---|
| In the screenshot example in Figure 1, such configurations can be presented with the following SQL. | Code Block |
|---|
| language | sql |
|---|
| title | Sample SQL |
|---|
| SELECT * FROM "Claim Entry" entry JOIN hr_expense_claim claim ON claim.id = entry.claim |
|
|
Image Added
Image Removed
Figure 2: Advanced Form Data Binder Properties - Advanced - Filter
| Name | Description |
|---|
| Filter Conditions | Filter Conditions | Name | Description |
|---|
| Join Type | | | 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
| | Value | Filter value. |
|
Image Removed
...
|
| 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 Modified |
| Info |
|---|
| You may even use operator such as "LIKE" to narrow down your data set. Image Modified |
| 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#' |
|
Image Added
Figure 3: Advanced Form Data Binder Properties - Advanced - Aggregate Query
| Info |
|---|
|
This is a new feature in Joget Workflow v6. |
| Name | Description |
|---|
| Aggregate Fields | |
| Group By | |
| Having Conditions | |