Kintana Script : List Steps without Statuses

Purpose

Forgetting to specify a step status name for a step is all too easy.

The workflow verify button catches a lot of problems, but missing step status names aren't one of them.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.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.

spool c:\steps_without_statuses_yyyymmdd.txt
set linesize 1000

select ww.workflow_name,
       wws.sort_order "step#",
       wws.step_name,
       wws.step_type_code,
       wws.parent_status "Request Status",
       wws.enabled_flag "Step Enabled"
from KWFL_WORKFLOW_STEPS wws,
     KWFL_WORKFLOWS ww
where wws.workflow_id = ww.workflow_id
--and ww.workflow_name = 'My Workflow Name'  -- Limit to one workflow
and ww.workflow_name = 'DG TEST : Prototype Patch Demand Workflow'
and wws.parent_status is NULL
and wws.step_type_code in ( 'APPROVAL', 'EXECUTION')
order by wws.parent_status, wws.step_type_code, wws.sort_order

spool off

WORKFLOW_NAME   Step#  STEP_NAME             STEP_TYPE_CODE  REQUEST_STATUS  Step Enabled
Main Inventory    5    Inspection Inwards    APPROVAL            [NULL]        Y
Main Inventory   62    Restock Packaging     APPROVAL            [NULL]        Y
Main Inventory   24    RFID update           DECISION            [NULL]        Y
...

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 (64 Kb)