Quite often there is a misunderstanding between displaying of a value and sorting upon the same. ApEx reports are giving you a possibility to show one value and sort upon a different value, which you even may not want to show to the user.
As always, I created a small example in my demo application containing a full explanation and a link to the corresponding thread in the forum:
http://htmldb.oracle.com/pls/otn/f?p=31517:153
It is easy to set it up and it shows the power of ApEx once again - it's simplicity.
Nice trick Denes!
ReplyDeletePatrick
You got me confused there for a minute, nice trick indeed!
ReplyDeleteHi Denes,
ReplyDeleteNice little trick , but how do you apply it to a column with a "img" HTML tag in it ? It seems the image is not displayed if the hiddent column contains this tag.