ODMR_USER_PROJECT_WORKFLOW

You can query all workflows that belong to a specific project or all projects by using the ODMR_USER_PROJECT_WORKFLOW repository view. This view provides information about the workflow, such as status, creation time, update time, and so on.

Table 8-10 provides more information about this view.

Table 8-10 ODMR_USER_PROJECT_WORKFLOW Repository View

Column Data Type Description

PROJECT_ID

NUMBER

This is the ID of the project in which the workflow was created in.

PROJECT_NAME

VARCHAR2 (30 CHAR)

This is the name of the project in which the workflow was created in.

PJ_CREATION_TIME

TIMESTAMP (6)

This is the project creation time.

PJ_LAST_UPDATED_TIME

TIMESTAMP (6)

Project last modified time stamp.

PJ_COMMENTS

VARCHAR2 (4000 CHAR)

These are comments related to the project, if any.

WORKFLOW_ID

NUMBER

This is the workflow ID.

WORKFLOW_NAME

VARCHAR2 (30 CHAR)

This is the name of the workflow.

WORKFLOW_DATA

XMLTYPE

This is the workflow metadata in XML format.

CHAIN_NAME

VARCHAR (30 CHAR)

This is for internal use only.

STATUS

VARCHAR (30 CHAR)

  • INACTIVE: Indicates that the workflow is idle.

  • ACTIVE: Indicates that the workflow is running.

  • QUEUED: Indicates that the workflow is in queue to run.

  • STOPPING: Indicates that the workflow is being stopped.

  • STOPPED: Indicates that the running workflow has stopped.

  • SCHEDULED: Indicates that the workflow is scheduled to run.

WF_CREATION_TIME

TIMESTAMP (6)

 This is the workflow creation time stamp.

WF_LAST_UPDATED_TIME

TIMESTAMP (6)

 This is the workflow last modified time stamp.

WF_COMMENTS

VARCHAR2 (4000 CHAR)

 These are comments related to the workflow, if any.

Parent topic: Repository Views