The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the calculated project overall health after it's overridden?

Highlighted
JudyZhu
Regular Collector

How to get the calculated project overall health after it's overridden?

Our customer requested to have both calculated/overridden project overall health displayed in a portlet.

 

I notice both of them share the value of “overall_health_indicator” of “PM_PROJECT_ROLLUP” table.

It seems the background “Project Health Service” would calculated the project health.

 

How to get the calculated project overall health from DB after it's overridden?

 

3 REPLIES
Celil
Esteemed Contributor

Re: How to get the calculated project overall health after it's overridden?

Hi judy,

 

It's not PM_PROJECT_ROLLUP table and as far as I see there isn't any table to store real health data. In 7.5 and maybe 8.0, there is a portlet named "Status Report Line Graph Portlet " shows project health history by line graph. (But this portlet removed in 9.1) In these versions you can get portlet view.

 

Celil

Celil

IT Governance Professional
& PPM Solution Architect
JudyZhu
Regular Collector

Re: How to get the calculated project overall health after it's overridden?

Hi Celil,

Thank you for the information.

We are using PPM 9.11. Do you have any idea again this version?
Celil
Esteemed Contributor

Re: How to get the calculated project overall health after it's overridden?

Hi Judy,

Unfortunately, I couldn't find any table in PPM 9.11 DB. But there is always another solution. You can write a triger that store changes in health another custom table. Then, you can query this history table and show them on portlet

Celil
Celil

IT Governance Professional
& PPM Solution Architect
//Add this to "OnDomLoad" event