Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to reset the column to be sorted by?

417474Jul 15 2004 — edited Jul 20 2004
I have a report that has many different sortable columns (the checkbox on Column Attributes page after the column). I would like the report be sorted by a column (something like priority) selected by developer always when an user enters the page, but user could also sort by any other column. But when the user comes to the page again on another day, another session, then the report should be sorted by the priority again. I have selected the priority column as Sort Sequence 1.

But I just dicovered, that HTMLDB is caching the column, that I have sorted by, even between different sessions (I mean close the window, log in with another window, navigate to the page and still see it to be sorted by the same column). RP in url (for example f?p=&APP_ID.:42:&APP_SESSION.::NO:RP:) or the page number on the same place (f?p=&APP_ID.:42:&APP_SESSION.::NO:42:) do not change anything. How can I clear cache for it or get it defaulted some other way?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2004
Added on Jul 15 2004
7 comments
485 views