Kintana Script : List Steps with duplicate names

Purpose

Cancelling a request and re-opening it to a specific step, pre-supposes that
the step names in the workflow your want to re-open to are unique.

The workflow verify button catches a lot of problems, but like missing step statuses
duplicate step 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:\check_list_for_duplicate_step_names_yyyymmdd.txt
set linesize 1000

select ww.workflow_name,
       wws.sort_order "step#", wws.step_name, cs.status_name
       wws.parent_status "Request Status", wws.enabled_flag "Step Enabled"
from KWFL_WORKFLOW_STEPS wws, KWFL_WORKFLOWS ww, KCRT_STATUSES cs
where wws.workflow_id = ww.workflow_id
  and ww.workflow_name = 'My Workflow Name'  -- Limit to one workflow
  and wws.parent_status = cs.status_id
  order by wws.status_name, wws.sort_order

spool off

WORKFLOW_NAME   Step#  STEP_NAME      STATUS_NAME
Main Inventory    5    Inspection     Awaiting Inwards Inspection
Main Inventory  102    Inspection     Awaiting DOD Inspection
...

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

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

Notes

This is also one more chance to review your step names for clarity and consistency
before the workflow goes into production.

Brevity is NOT a virtue here. Use as many words as you need to clearly describe the
step's purpose.

Download

KintanaScripts.zip (58 Kb)