Show Overall Status on Grid

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

How can I display the Overall Status value from a Status Report onto a Project/Custom Investment. How can this be accomplished?

Environment

Release : 15.9.3

Component : PPMSTU

Resolution

A new attribute can be created on object with the following information:

Attribute Name and Attribute ID - Any desired value

Data Type - Aggregated

Result Data Type - Number

Calculation - AGG_Max(cop_prj_statusrpt.cop_overall_status)

Filter - 

Use Expression:

cop_prj_statusrpt.last_updated_date == cop_prj_statusrpt.last_updated_date &&  ( cop_prj_statusrpt.cop_report_status ==  lookup("OBJ_STATUSREPORT_REPORT_STATUS", "FINAL") )

API Attribute ID - Specify a value to use in the MUX

 

Once created add the attribute to the  grid to see the numeral value of the Status Report.