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