08-04-2009 04:16 PM
We are using Proposals and Projects in PPM. In Proposals, we are using the standard 'Plannd Start Period' and 'Planned Finish Period' fields, which by default are year-month, as 'January 2009', 'February 2009', etc.
Users would like to include these fields in portlets, and sort by the values. However, it doesn't work the way we want! The sort results will look something like:
Is there any way to get these rows to sort in a logical manner? The only thing I can think of is to change the values to be YYYY MM.
08-04-2009 09:54 PM
I think, you are sorting by period name(visible_parameter). Try sorting by Period_id(parameter),i.e. PRJ_PLAN_START_PERIOD_ID. This should work.
08-04-2009 09:59 PM
The Above value is 'Period Name' is present in the Table called 'KNTA_PERIODS' join this table in your Query and add a order by clause called 'Period_id' or 'SEQ'
Select * from KNTA_PERIODS where PERIOD_TYPE='MONTH' order by Period_id
Kindly let me know if you face any issues.
08-05-2009 09:03 AM
08-05-2009 09:44 PM
I have not tried on this, but it is worth to give a try, See the Query which gets fired when you run the Request List Portlet, Or you can drill down RequestList.Jsp file from 'deploy/itg.war/web/knta/crt' location.
See if you can do modification in the JSP files.
04-19-2013 08:44 AM
I am having this issue now.. I couple options to pursue:
1. Create a separate field and Planned Finish Day -- then either ask users to fill in that field. Or create a rule that will grab the start date then populated it with that field. Then use the portlet to report on that new field.