This content has been marked as final. Show 6 replies
Are you defining the LOV by a SELECT? Here is one of mine:
You can add an "order by" clause. Ignore the "group by" I was just getting fancy.
select SYS_NM||'/'||NIC_NM as display_value, SYS_NM||'/'||NIC_NM as return_value from NTWRK_PKT_CNT group by SYS_NM||'/'||NIC_NM, SYS_NM||'/'||NIC_NM order by 1
If SELECT col1, col2, col3 FROM table_x is your query where col2 is your select list based on Named LOV, then
If you want to sort the report based on value selected in select list use this query
SELECT col1, col2, col3 FROM table_x ORDER BY 2
If you want to sort the values in the select list which should be something like this
SELECT col1 as display_value, col2 as return_value from table_y order by 1
Are You using an APEX_ITEM.SELECT_LIST_FROM_LOV(), or similar function, in the report select statement to create the lov?
Thank u all for your reply.
If fact, i want to make it work this way: when the user click the title of that column, he can sort any way he want.
Normally -- as far as I know -- if you want the user to sort something, it's usually data in a report. APEX provides ways to do that. You can click on the report column header. I don't know of any standard feature to allow the user to sort an LOV -- but it would be an interesting feature.
- what sort options would you want: ascending, descending, other. .. ???
- where would they click to indicate how they wanted ascending, descending or other?
But maybe someone knows better than me.
Sorry, maybe i don't make it clear. The column i want to sort is Editable in the report. After i check the sort attributes, i got the error message.