Kintana Script : Workflow steps Visible on a package-line status tab

Purpose

Whether a user sees a workflow step column on a package-line's status tab depends on several settings.

The workflow step itself can be set to either not display at all or only display transiently.

However, whether a user sees every step in the line status panel depends also on the individual user's profile settings.

If a user complains that a step for a particular workflow is not showing up, you need to first check the workflow's step setting.

It's not too obvious where to locate the user's preference information. This script will locate it for you.

Tested

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

Usage

Paste the script into Toad or 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:\deliver_status_tab_visible_workflow_steps_yyyymmdd.txt
set linesize 1000

select nu.first_name || ' ' || nu.last_name,

-- Determines whether all workflow steps are shown within workflow status panels
-- Set to Y

nup.show_all_workflow_steps_flag,

-- Determines whether steps that have been traversed and are no longer active
-- are shown within workflow status panels
-- Set to Y

nup.show_traversed_steps_flag,

-- Determines whether or not workflow steps based upon immediate executions and
-- conditions are shown within workflow status panels
-- Set to N

nup.hide_immediate_steps_flag

from KNTA_USER_PROFILES nup,
    KNTA_USERS nu
where nup.user_id = nu.user_id
-- and nu.first_name = 'David'
-- and nu.last_name = 'Goodall'

spool off

USER          show_all_workflow_steps_flag  show_traversed_steps_flag  hide_immediate_steps_flag

Dave Goodall           Y                            Y                          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)