This content has been marked as final. Show 5 replies
You can go to this URL to see the issue I'm having
You can see the dept list and emp (deptno + empno). If you change the dept the emp list still stays the same even if I have a dynamic action to refresh the emp.
the issue here is that the session state of the item global_dept is not changing if you select some other department because your page is not submitted.
Therefore the emp list isn't updated for the selected department.
You could make the dept select list auto submit the page or add an action to your dynamic action to set the session state of global_dept with the selected department.
Make sure you place this action before the refresh of the emp region.
Thanks for the info and just 1 question how do you set the session state of the global_dept?
If I have a choice I do not want to do the submit since later on I would have other codes that would fire when doing a submit.
to set the session state of global_dept add an action of type "Execute PL/SQL Code"
For the PL/SQL code use the statement null;
Set the Page Items to Submit to global_dept.
I create a dyynamic actions on the global_dept
Action: Execute PL/SQL
Page Item to Submit: global_dept
Selection Rtpe Region
When I run this it does not seem to do anything.