Kintana Script : List Workflow Step Names and Statuses

Purpose

Useful for explaining to new users the status associated with each step of the specified workflow. They need to be familiar, when interpreting reports, or looking at the graphical workflow display, with the state of progress achieved when a request has advanced to a given step.

This pre-supposes that the status for each step is unique. If steps in the workflow use the same same status e.g 'Waiting for information', then the usefulness of this list is reduced. However the status names for steps on the critical path through a workflow are usually distinctive.

Also useful for generating workflow documentation.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the following script into SQL Runner

Change the workflow name literal to the workflow name you want to list.

Omit the comment unless you're using a PL-SQL editor.
SQL Runner only supports select statements and you'll get a KNTA-10648 error.

-- List Workflow Step Names and Statuses

select ww.workflow_name, wws.sort_order "Step No",
       wws.step_name, cs.status_name
from KWFL_WORKFLOWS ww, KWFL_WORKFLOW_STEPS wws, KCRT_STATUSES cs
where wws.workflow_id = ww.workflow_id

--and ww.workflow_name = 'Restock Inventory'
and ww.workflow_name like '%Inventory%'

and wws.parent_status = cs.status_id
order by wws.sort_order

WorkFlow_Name Step No  Step_Name          Status
-------       -------  ------------------ ------------------------
Returns       1        Return Item        Unreleased
Returns       2        Inwards Inspection Pending Inspection
Returns       3        Generate Bin Route Awaiting docket
Returns       4        Restocked          Bin Accession
Returns       5        Closed             Close (Immediate success)
Returns       6        Identify SKU       Pending Inventory Match
Returns       7        Match to Sales     Pending Ledger Match

To extract the output, click on the [Open as Text] button.

This opens a text window from which you can copy and paste.

Notes

If the workflow you are interested in contains sub-workflows then you'll need to run this script for each subworkflow to list all their statuses.

Download

KintanaScripts.zip (64 Kb)