Project and Portfolio Management Practitioners Forum
cancel

How to control the color of a progress indicator in a portlet

SOLVED
Go to solution
Highlighted
Mike Ramberg
Valued Contributor.

How to control the color of a progress indicator in a portlet

I am using a progress indicator in a custom request list portlet. There is a field associated with it called color source. What are the valid values for this field? I would like to show Red Green Yellow, but no matter what I try, I can not get color to show in the progress indicator. I am on PPM version 6.0 Service pack 17

Thanks
2 REPLIES
Jason Nichols K
Acclaimed Contributor.
Solution

Re: How to control the color of a progress indicator in a portlet

Mike,

Could you provide the SQL you are using for the portlet? You need to have the color that you want it to be as one of the "column" of data that's returned. So, if you have something like

SELECT r.request_id
, ROUND(NVL(wta.PERC_COMPLETE, 0),2) percComp
, case
WHEN ROUND(NVL(wta.PERC_COMPLETE, 0),2) <= 33 THEN 'RED'
WHEN ROUND(NVL(wta.PERC_COMPLETE, 0),2) > 33 AND ROUND(NVL(wta.PERC_COMPLETE, 0),2) <= 67 THEN 'YELLOW'
ELSE 'GREEN'
end COLOR
FROM PM_WORK_PLANS pwp
, WP_TASKS wt
, WP_TASK_ACTUALS wta
, KCRT_FG_PFM_PROJECT fg
, kcrt_requests r
WHERE fg.REQUEST_ID = r.REQUEST_ID
AND fg.PRJ_PROJECT_ID = pwp.PROJECT_ID
AND pwp.ENTITY_TYPE = 'WORK_PLAN'
AND pwp.ROOT_TASK_ID = wt.TASK_ID
AND wt.SEQUENCE_NUMBER = 0
AND wt.TASK_ACTUALS_ID = wta.ACTUALS_ID;

This code is just an example of being able to associate a color name to the different percent complete values. You can change the intervals, and you can also use the HTML Color codes so you get the colors you are expecting. Hope this helps.

Jason
Mike Ramberg
Valued Contributor.

Re: How to control the color of a progress indicator in a portlet

Thanks Jason! I almost had it, but was using 'Red', 'Yellow', "Green" (without caps) Using Caps has it working.