Is there any column in any of the workflow schema to distinguish execution? | Community
Skip to main content
December 30, 2024
Solved

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

  • December 30, 2024
  • 1 reply
  • 600 views

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.
Best answer by LakshmiPravallika

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
December 31, 2024

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.