Kintana Script : Standardizing Icon Usage

Purpose

You need to be very consistent about the icons you use for workflow steps.
To make the system easy for users you should use the same icon to represent the same action.

Icons are stored in the {KINTANA_HOME}\icons directory.

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 if you're using SQL RUNNER.
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:\icon_usage_yyyymmdd.txt
set linesize 1000

select unique wa.icon_name "Icon Name" , wa.approval_name "Step Name", 'APPROVAL' "Step Type"
from KWFL_APPROVALS wa
where wa.icon_name is not NULL

union

select unique we.icon_name "Icon Name" , we.execution_name "Step Name", 'EXECUTION' "Step Type"
from KWFL_EXECUTIONS we
where we.icon_name is not NULL

union

select unique wc.icon_name "Icon Name", wc.condition_name "Step Name", 'CONDITION' "Step Type"
from KWFL_CONDITIONS wc
where wc.icon_name is not NULL

union

select unique ww.icon_name "Icon Name", ww.workflow_name "Step Name", 'WORKFLOW' "Step Type"
from KWFL_WORKFLOWS ww
where ww.icon_name is not NULL

spool off

Icon Name       Step Name                Step Type

approval.gif    Review Request           APPROVAL
requestor.gif,  PMO Requestor Sign-off   APPROVAL
signoff.gif     Signoff                  APPROVAL
holdstatus.gif  Hold for Approval        EXECUTION
checkresult.gif Branch on test result    EXECUTION
...

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)