Hi,
I am using 5.1.4.00.08 of APEX. I want to sort a varchar2 column that contains numbers and letters, as a number. For example, the column contains following data:
DR/2020/1
DR/2020/2
DR/2020/13
DR/2020/4
And if we change the sorting to ascending or descending, the report show following output:
DR/2020/1
DR/2020/13
DR/2020/2
DR/2020/4
And I wait following output (ordered by the last number /XX):
DR/2020/1
DR/2020/2
DR/2020/4
DR/2020/13
Does anyone know how to change the order criterial? it seems it is taking alphanumeric criterial.
Are there any option in APEX to display a different value in the column, and sort by another substring of this column?
Kind Regards,
Fran.