workflow tables relation

Avatar

Avatar

ankitkochar

Avatar

ankitkochar

ankitkochar

02-11-2018

Hi all,

Does any one know hierarchy / relation between different xtkworkflow% schema's i.e. below

XtkWorkflow (Workflows)

XtkWorkflowEvent (Event)

XtkWorkflowJob (Workflow in waiting state)

XtkWorkflowLog (Log list)

XtkWorkflowLogin (List of logins)

XtkWorkflowTask (Elementary task)

I understand xtkworkflow contains metadata details of each and every workflow, how does other workflow related tables gets populated. For example, what exactly is relation between workflowevent & workflowtask etc.

Regards,

Ankit

View Entire Topic

Avatar

Avatar

Debabrata_T

Avatar

Debabrata_T

Debabrata_T

06-11-2018

Hi ankitkochar,

Hope this helps.

xtk:workflow - Stores metadata and execution information of workflows.

xtk:workflowLog - Stores logs of each task of each workflow execution.

xtk:workflowTask - Stores information of each task of each workflow execution.

xtk:workflowEvent - Stores what message is transitioned from one task to another in each workflow execution.

xtk:workflowJob - Stores information about waiting tasks of a workflow.

xtk:workflowLogin - Stores with which login the workflow is executed. If the operator is inactive your workflow will throw error.

For a more practical understanding, you can get the id of an workflow and try to filter in all these schemas.

Regards,

Deb