Hello All,
I am working with Oracle APEX 24 and have an Interactive Report where users can sort columns by clicking on the column headers. However, I would like to ensure that null values always appear at the end when sorting a column, regardless of whether it's sorted in ascending or descending order.
I am aware that this can be done through the Actions section, but this setting is only available for up to 6 columns. Since I have around 20 numeric columns that can be sorted, this solution does not fully meet my requirements.
Is there a way to configure this behavior within APEX? Or is there a session parameter or setting that can be applied to achieve this?
Alternatively, is there a setting in Oracle Database to always place null values at the end when sorting, regardless of the query or sorting logic?
Any guidance or suggestions would be greatly appreciated!
Thank you!