ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Show Overall Status on Project Grid

book

Article ID: 226734

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

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

 

Environment

Release : 15.9.3

Component : PPMSTU

Resolution

A new attribute can be created for Project 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 Project grid to see the numeral value of the Status Report.