Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

当表单被映射到流程活动时,Joget将使用PID作为Application Form表格中的主键来创建一个记录行。如果使用Form Data Update Tool (Enterprise)

...

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.

更新同一个表单,Joget将能够找到数据库表并使用PID匹配主键(PK)。

如果您尝试更新不是流程的一部分的表单,情况会变得棘手。Joget将无法使用相同的PID来匹配记录行。

表名 Table Name:

transactions

PK

id

 

name

FK

account_no

Figure 1: Transaction table which is mapped to the process activity.图1:映射到流程活动的事务表。

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.图2:账户表,它不是流程活动的一部分,但与Transaction表有关系


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.

图3:帐户表的表单数据更新工具的映射。

解决方案很简单。人们只需要在Update Fields部分定义一个“id”字段。说明对应于表单记录标识符的值。