Portlet sorting by date-period fields

Hi,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:April 2008April 2009August 2008August 2009December 2008...etc.

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.

Re: Portlet sorting by date-period fields

Thanks for the input. However, I'm not dealing with a custom portlet. If I were building a custom portlet, I could code around this issue. I'm more concerned with the out-of-the-box portlets that my customers use. 'Request List' is one example. I don't think the customers have the ability to change the way it sorts, nor the ability to sort on non-displayed fields.

Re: Portlet sorting by date-period fields

Hi,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.

Re: Portlet sorting by date-period fields

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.