I have a report with one column which is Select List(named LOV). I want to sort that column,
however, i got an error: failed to parse SQL query:
ORA-01403: no data found
If i don't sort it, the report is working fine.
What caused the problems? Thanks for your help.
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.