Share this page

# MREL_DISTRIBUTION_ACTIONS

Used to gather information about current workflow steps for any given release distribution in Deployment Management. Contains columns to display the current status of a step, how long that step has been in the current status, whether the step is complete or resulted in an error, details about the step (source and destination Environment), and other relevant details.

To relate information from this view with information from related releases or release distributions, the report designer can use the release and distribution identifiers (RELEASE_ID and DISTRIBUTION_ID columns) to join with other standard views like MREL_RELEASES and MREL_DISTRIBUTIONS.

Sample

A report is needed that takes a release name input from the user running the report, and shows the details of all open distributions of the release:

    SELECT release_name                           RELEASE_NAME,
           distribution_name                      DISTRIBUTION_NAME,
           dist_workflow_step_label || ': '|| action_name
                                                  ELIGIBLE_STEP,
           duration                               DAYS_ELIGIBLE
    FROM   mrel_distribution_actions
    WHERE  status_type = 'ELIGIBLE'
    GROUP BY release_name,
             distribution_name,
             dist_workflow_step_label || ': '|| action_name,
             duration
    ORDER BY 1,2;

The column STATUS is the status name that is displayed in the status tab of distributions in the Deployment Management application.

The internal code STATUS_TYPE is provided to group these status names into logical groupings. For example, there may be many different statuses that all represent a COMPLETE status type. For example, the result value of any workflow step like Approved, Succeeded, Rejected, or Failed QA Test.

While STATUS may have many different possible values, STATUS_TYPE has only the following possible values:

- SUBMITTED

- IN_PROGRESS

- CLOSED_SUCCESS

- ELIGIBLE

- ERROR

- CLOSED_FAILURE

- PENDING

- COMPLETE

- CANCELLED

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: