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
Re: How to control the color of a progress indicator in a portlet
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.