Hi,
I have an issue with concepts of session states in APEX 5, which I'm not very familiar with and could use some help. I would love to read documentation but when I have enough time...
Because it takes time, I will replicate example on apex.com only when it will become impossible to explain where problem might be, and becomes necessary, but I hope I'm just missing some step here...
In short I have a form upon table with report. Form represents regions. So on this page I have item of region ID; P57_ID along with other fields relating to table, but P57_ID is PK.
I have automatic row fetch process After Header from the region table (primary key column: ID, primary key item: P57_ID).
For P57_ID item: source: database column, column: ID, and the use is: Always, replacing any existing value in session state. Maintain Session State: Per User. (tried with Per Session also)
Say, I have a user named user1. He is assigned to region that has ID = 1. This user then goes to report page and edits row of region 1, is redirected to form (page 57), and here he can save changes for region 1. But now I want to change region to which this user belongs to, so I assign him to region that has ID = 2. ,
Now when I login back as user1, and go to page 57 (form), it will contain data from older region (ID 1). And that is the problem. Instead, he should see data from new region assigned to him, or perhaps blank form (doesn't really matter), but definitely not old/previous data.
So I need old data cleared up or unavailable here. I tried calculations for item, dynamic actions, default value, but no success.
When I create Clear Session State process in Before Header, then it fixed part of problem, it doesn't show old data inside form, but then if I go to edit icon on report page which redirects me to the form, the fields are blank.
If I could explain good enough what I want to achieve, is there a specific way to do it?