...
As alternate workflow is introduced, this problem will be solved by allowing in-progress workflow instances to be isolated from the latest FAB workflow changes. Old instances in production will continue to use the WF Definition in the point of time it was created. In the same manner, new instances will automatically use the latest workflow definition.
Auto-versioning
Changing the workflow definition automatically increments the WF version.
To deactivate this feature, follow these steps: https://iqxbusiness.atlassian.net/l/cp/QuU2TqTU
Related Tables
/IQX/FAB_WF - FAB Enhanced Workflow Definition
Repurposed fields to support featuresFeatures:
WF instance - fields ZDEFINITION, MD5_CHECKSUM
Multiple workflows per Project - incrementing ZITERATION_NO
Default workflow - IS_DEFAULT
Traceability - fields MODIFIED_*
Repurposed Fields:
ZITERATION_NO: incrementing, to be used as WF Version
ID: to be used as WF ID
ZID: to be used as WF Description
New Fields:
Field | Key | Type | Description |
|---|---|---|---|
ZDEFAULT | BOOLEAN | Indication for default Workflow ID | |
MD5_CHECKSUM | HASH160 | MD5 generation from ZDEFINITION, to be used as key in | |
MODIFIED_BY | CHAR 12 | Modified By | |
MODIFIED_DATE | DATS 8 | FAB Changed on date | |
MODIFIED_TIME | TIMS 6 | FAB Changed at time |
/IQX/FORMHD_INST - FAB Form Header Instance Data (run-time values)
New Fields:
Field | Key | Type | Description |
|---|---|---|---|
WF_INSTANCE | FK | HASH160 | WF Instance |
IS_TERMINATED |
| BOOLEAN | Is FAB Instance EOL |
/IQX/FAB_WF_INST - FAB - Enhanced Workflow Instance (New Table)
To store the definition snapshot of WF Definition when a FAB instance is submitted.
Fields:
Field | KEY | Type | Description |
|---|---|---|---|
ZWF_INSTANCE | PK | HASH160 | WF Instance (MD5) |
ZFORM_NAME | FK | CHAR 24 | FAB Project ID |
ID | FK | NUMC 6 | Workflow ID |
ZITERATION_NO | FK | NUMC 6 | Workflow Version |
ZDEFINITION |
| STRING | WF Definition in JSON |
Traceability
To track back changes in workflow definition, you may use the following field relations:
/IQX/FORMHD_INST-WF_INSTANCE - contains the Hash Characters for WF definition version in which the instance run
Plug in /IQX/FORMHD_INST-WF_INSTANCE to /IQX/FAB_WF-MD5_CHECKSUM to know the version number for said WF definition.
/IQX/FAB_WF-MODIFIED_* fields show changes in WF definition version.
Plug in /IQX/FORMHD_INST-WF_INSTANCE to /IQX/FAB_WF_INST-WF_INSTANCE to know more on the details of current WF definition used.
/IQX/FAB_WF_INST-CREATED_* fields show details of WF Definition creation
