Skip to main content
New Member
Dec 30, 2024 1:33 PM UTC
Solved

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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
LakshmiPravallika
LakshmiPravallikaAccepted solution
Community Advisor
Dec 31, 2024 11:42 AM UTC

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.

 

1 reply

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity AdvisorAccepted solution
Community Advisor
Dec 31, 2024 11:42 AM UTC

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.

 

Translate