Sort group data in custom sort order

[2006 IR Open Dicussion]

By: priyas - priyas

Sort group data in custom sort order

2006-07-31 05:48

Hello,

 

Is it possible to sort a group's data according to an application specific order?

 

Say I have a table column called "Priority" in the database and it stores text like "P1", "P2", "P3", etc. When I display report in table form, I want to sort these values in a preferred order like "P5", "P1", "P2" etc. This preferred order can be changed at runtime.

 

I know that this can be easily done using "field" function in "Order by" clause. I am looking out for a java solution as the number of records to process in database are more.

 

Thanks in advance for any help.