Kintana Script : Workflow Step Transitions

Purpose

Documents the step to step flow for a specified workflow.

Tested

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

Usage

Paste the script into SQL Runner

Omit the comment, spool, and linesize statements unless you're using a PL-SQL editor. SQL Runner only supports select statements and you'll get a KNTA-10648 error. If using PL-SQL change 'yyyymmdd' in the output file name to today's date.

-- List Workflow Step Transitions
spool c:\workflow_step_transitions_yyyymmdd.txt
set linesize 1000

select ww.workflow_name,
       wws1.sort_order "From Step No",
       wws1.step_name,
       wws2.sort_order "To Step No",
       wws2.step_name
       wst.transition_type_code "If",
       wst.operator_code "Is",
       wst.result_value "Value",
       wst.visible_result_value "Transition",
from KWFL_WORKFLOWS ww,
     KWFL_WORKFLOW_STEPS wws1,
     KWFL_WORKFLOW_STEPS wws2,
     KWFL_STEP_TRANSITIONS wst
where ww.workflow_name = 'My Workflow'
  and ww.workflow_id = wws1.workflow_id
  and wws1.workflow_step_id = wst.from_workflow_step_id
  and wst.to_workflow_step_id = wws2.workflow_step_id
order by wws1.sort_order

spool off

WORKFLOW_NAME,   From Step No  STEP_NAME       To Step No     STEP_NAME    If               Is    Value   Transition
My Workflow      22            Goods Inwards   23             Restocking   SPECIFIC_VALUES  =     ACCEPT   Accepted
My Workflow      23            Restocking      54             Bin Control  SPECIFIC_VALUES  =     REJECT   Rejected
...

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

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

Download

KintanaScripts.zip (79 Kb)