Project and Portfolio Management Practitioners Forum
cancel

Can project health be shown as a displayed color in portlet

Highlighted
ramana.vkn
Super Contributor.

Can project health be shown as a displayed color in portlet

Hi,

Can project health be shown as a displayed color in customized portlet?
15 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Can project health be shown as a displayed color in portlet

Sure. PM_PROJECT_ROLLUP contains the fields you need, just use them in your query and set the fields to type 'Icon' in your portlet definition, then you will get the little colored square indicators.
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

Hi Erik,

On portlet definition I have set the field to type 'Icon', but the when I access the dashboard it is throwing the error.
I have attached the query and the log file.
Erik Cole
Acclaimed Contributor.

Re: Can project health be shown as a displayed color in portlet

You have to use a field that returns a color name, like 'Red' or 'Yellow'. Look in that table I posted above.
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

Hi Erik,

PROJECT_HEALTH_MEANING column of KCRT_FIELD_GROUP_DETAILS_V returns Red, Greeen etc.
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

Can some one help me solving this issue please
Erik Cole
Acclaimed Contributor.

Re: Can project health be shown as a displayed color in portlet

Can you post a snapshot of your portlet def?
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

Hi Erik,

Attached the screen shot of protlet definition.
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

Hi Erik,

Attached the screen shot of protlet definition .
Erik Cole
Acclaimed Contributor.

Re: Can project health be shown as a displayed color in portlet

One more thing to check...in your data source, do you have the icon field set to a Column Type of 'Summary Condition/Exception'?
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

Hi Erik,

Tried that, but I am getting the error.
I have attached the screen shot of the error.
Erik Cole
Acclaimed Contributor.

Re: Can project health be shown as a displayed color in portlet

Now that's a different error. Have you tried adding a filter, or modifying your query to only return a few rows for testing?
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

I have modified query, i am using pm_project_list_v table to get project health.
This is the query I am using
(select distinct overall_project_health from pm_project_list_v where project_id=kfgd.prj_project_id)
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

Hi Erik,

This the query I am using, please let me know if this needs to be modified.

SELECT Kfgd.PRJ_PROJECT_MANAGER_USERNAME PROJECT_MGR, KPRL.STATUS_NAME PROJECT_STATUS, kprl.REQUEST_NUMBER PROJECT_NUMBER_HYPERLINK, kprl.REQUEST_NUMBER PROJECT_NUMBER, kfgd.PROJECT_HEALTH_MEANING PROJECT_HEALTH, kfgd.PROJECT_NAME PROJECT_NAME, TO_CHAR(kfgd.PRJ_PLAN_START_PERIOD_NAME) PLANNED_START_DATE, TO_CHAR(kfgd.PRJ_PLAN_FINISH_PERIOD_NAME) PLANNED_FINISH_DATE, DBMS_LOB.SUBSTR(kn.NOTE, 6000) NOTES
FROM KCRT_PORTLET_REQUEST_LIST_V kprl, KCRT_FIELD_GROUP_DETAILS_V kfgd Left Join KNTA_NOTE_ENTRIES kn on kfgd.REQUEST_ID = kn.PARENT_ENTITY_PRIMARY_KEY
WHERE kprl.request_id in (select request_id from kcrt_requests kr
where (status_code NOT LIKE 'CLOSED%' AND status_code NOT LIKE 'CANCEL%'))
AND kprl.REQUEST_ID = krhd.REQUEST_ID
AND kprl.REQUEST_ID = kfgd.REQUEST_ID
ramana.vkn
Super Contributor.

Re: Can project health be shown as a displayed color in portlet

Hi Erik,

Do you see any issues with the above query in displaying the project health?
Erik Cole
Acclaimed Contributor.

Re: Can project health be shown as a displayed color in portlet

Couple of things...

(1) You have nothing limiting the request type(s) returned to just projects, which may be why you are getting that 'load time exceeded' error.

(2) You are not going to be able to get 6000 char of notes into a portlet field, I'd suggest limiting it to something much more reasonable.

(3) Your portlet definition seems okay, as long as the field you're using for the icon is set as 'Summary Condition/Exception' in the data source.