Hi together,
I'm still working with APEX 5.1. / Oracle 11.2.0.4.
Order-by-clause is not allowed in interactive grid.
So I use Actions / Data / Sort.
I need a sort sequence depending on column-content, but not in alphabetic sequence.
For example this table is sorted in alphabetic sequence:
Job
manager
president
salesman
I want to use a column sortsequence:
Job sortsequence
president 1
salesman 2
manager 3
sortsequence is a column created in sql query.
For using the sortsequence in Actions / Data / Sort it must be visible, not hidden. But for the user it should be hidden.
So how to hide the sortsequence?
My Idea is to set a fixed column width = 1 Pixel. But in column properties I only find "minimum width".
Is there any way to fix this problem?
Thanks a lot!
Greetings Thilo