What is a method to view the task hierarchy from the Clarity tables?
Clarity 16.3.1
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