CODEWITHSUNDEEP
oracle-databasesession-stateoracle-apex
Hung Huynh
Hung Huynh

Reputation: 13

Session State Oracle Application Express

I am working with Oracle Application Express. I am running into what I think is a session state issue. So here is my issue.

  1. I have two machines, with two different web browsers.
  2. Machine 1 sort on column 1 and machine 2 is sort of column 2
  3. Machine 1 I sort on column 3
  4. I refresh the page on Machine 2 and the sort moves to column 3

Does anyone know why?

Upvotes: 1

Views: 908

Answers (1)

Paran0a
Paran0a

Reputation: 3457

If you are not using any kind of authentication then apex saves column sorting "globally". ie apex doesn't know for who it should save sorting.

For example if you had authentication in your application every users sorting preferences would be saved in apex.

If you wish to reset sorting on every page load read into these docs

http://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25309/api.htm#CHDIBDEC

Also look at this explanation about preferences

Managing User Preferences

You can use preferences to store values for a specific Application Express user across distinct sessions. Once set, these preferences can be removed programmatically or manually. You can set user preferences by creating a page process, by the calculation of a preference Item Source Value, or programmatically by using a PL/SQL API.

Source : https://docs.oracle.com/cd/E18283_01/appdev.112/e12512/aadm_mg_sessions.htm

Upvotes: 1

Related Questions