Method To View Representation of Task Hierarchy

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

What is a method to view the task hierarchy from the Clarity tables?

Environment

Clarity 16.3.1

Resolution

The following query can can be used to review the
Modern > Project > Task > Timeline view and/or Gantt view

SELECT prname, prwbslevel, WBS_NNBSEQ, WBS_PARSEQ
FROM prtask
WHERE prprojectid = 5xxxxxx --example project
order by prwbssequence

This can then be correlated to the DWH_INV_TASK table on the DWH database.

SELECT TASK_NAME, wbs_level, WBS_SEQUENCE
FROM DWH_INV_TASK
WHERE investment_key =  5xxxxxx --example project
order by WBS_SEQUENCE