Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
...
Things get tricky if you are trying to update a Form that is NOT directly part of the flow. Joget will not be able to use the same PID to match the record row.
Table Name: | transactions |
---|---|
PK | id |
| name |
FK | account_no |
Figure 1: Transaction table which is mapped to the process activity.
Table Name: | accounts |
---|---|
PK | id |
| name |
| expiry |
Figure 2: Account table which is not part of the process activity but has relationship to the Transaction table.
Figure 3: Mapping of Form Data Update Tool for Account table.
The solution is simple. One will simply need to define a "id" field in the Update Fields section. State the value that would correspond to the record identifier of the Form.
Table Name: | transactions |
---|---|
PK | id |
| name |
FK | account_no |
...
Table Name:
...
accounts
...
PK
...
id
...
...
name
...
...