Versions Compared

Old Version 5

changes.mady.by.user Hugo

Saved on

compared with

New Version Current

changes.mady.by.user Hugo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColorgreen
borderWidth1
titleBGColor#ddffcc
borderStylesolid
titleDefinition

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.

Panel
borderColorredpurple
borderWidth1
titleBGColor#ffcccc#ddccff
borderStylesolid
titleNew Feature

This feature has been enhanced in Joget Workflow v6 to support join, group and aggregate function.

Image RemovedImage Added

Figure 1: Advanced Form Data Binder Properties

NameDescription
FormSource form to retrieve data from.
Joins Form Data Table
Info
titleNew Feature

This is a new feature in Joget Workflow v6.

NameDescription
Form Data Table NameTarget table to join with
FieldTarget table field to join with
Join Field IdParent field Id to join with
Info
titleSample

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

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

 

 


Image AddedImage Removed

Figure 2: Advanced Form Data Binder Properties - Advanced - Filter

...

The configurations shown in Figure 3 will produce the following sample result.

Figure 4: Sample result

Image Added

Figure 5: Advanced Form Data Binder Properties - Advanced - Expression Columns

Info
titleNew Feature

This is a new feature in Joget Workflow v6.

NameDescription
Expression Columns

Additional column can be added in this expression columns. This is especially useful when you need to perform additional computation on multiple columns.

Code Block
titleSample
CAST(price AS long)
Code Block
titleSample
CAST(e.customProperties.sales_price AS long) - CAST(e.customProperties.price AS long)

 

 

Custom Checkbox/Radio Button Value

Define custom record ID to be used to pass over to column action. Defaulted to ID.

Image Added