Hi All,
I am using Oracle APEX 24.1 with a Classic Report
Requirement: I want the 2nd column to be sorted by default (Ascending) for all users when the page loads.
Configuration done:
- Removed ORDER BY from the SQL query
- On the 2nd column:
- Sortable = Yes
- Sort Sequence = 1
- Default Sort Direction = Ascending
- No other column has a Sort Sequence defined
However, when the page loads, the report does not apply the configured default sort.
Questions:
- Does Classic Report in APEX 24.1 ignore Default Sort Sequence under certain conditions?
- What is the correct approach to enforce a default sort for all users?
- Is there an official way to reset Classic Report sort state
Any suggestions would be appreciated.
Note: I cant disbaled first column sort and need solution for UI not like change repeort add order By