Is there any column in any of the workflow schema to distinguish execution?

[SankaravelNa]

Hi all,

Is there any column in any of the workflow schema to distinguish execution? i mean unique field/identifier for workflow execution

thanks, sankaravel n

[LakshmiPravallika · Accepted solution]

Hi @SankaravelNa ,

There is no OOTB Column which provides the unique identifier for each execution, But you can utilize the audit logs to get the distinct executions for each workflow...by querying the xtk:audit schema with conditions @entityType equal to workflow and @actionType equal to start and get the audit ID Entry for each start.

If required, you can also create a custom field within your workflows, such as executionID or executionTimestamp, to explicitly track each execution, by extending the OOTB Schema xtk:workflow, and in workflow script or within the process of your workflow, you can generate a unique identifier (executionID), for instance, using the UUID function to distinguish between different executions.

Script can be written:

var executionID = generateUUID();

and store this value in the custom field of the extended schema.

Regards,

Pravallika.