Project and Portfolio Management Practitioners Forum
cancel

order by statement not working in portlet results

Highlighted
Jajcen Harris
Valued Contributor.

order by statement not working in portlet results

Hello all,

I created a portlet for which our users wanted a specific default order by sql clause. when i add the clause to the query on the order by tab of the datasource, it shows up in the full query view, but doesnt work. i put the full query into sql developer and it worked there. has anyone else ran into this issue?
3 REPLIES
Laura Walker
Contributor.

Re: order by statement not working in portlet results

As I recall, if the query returns more than 200 rows, the order by clause will not work, and in fact what is returned in the portlet may even seem sort of random. This is a known issue with HP - I don't remember if they said they were going to address it or not.
Jajcen Harris
Valued Contributor.

Re: order by statement not working in portlet results

Hello Laura,

Thank you for your input! I figured out what the issue was. Since I made the portlet columns user sortable, it would not allow a default order by. I had to make it so that the portlet was not user sortable by clicking on the table columns.

Thanks!

Jajcen
Jajcen Harris
Valued Contributor.

Re: order by statement not working in portlet results

solved.