I'm using 4.2 Apex, Oracle 220.127.116.11 DB, IE 8 browser, pl/sql Gateway architecture and I'm using them 24 cloudy theme.
I basically have a global page with 2 regions
Type: html text
Display Point Page Template Region Position 2
Display as Select List
List of Values is based on a named lov 'dept' -- this is based on a select of all valid dept
Type: List: emp -- this is based on a list which is based on a select statement below;
List Template: Vertical Side Bar
Display Point: Page Template Region Position 2
Template: Hide and Show Region (hidden first) - Borderless
If I go to shared component->list->emp
where deptno = :global_dept
-- take note part of the where, I referenced the global_dept item that I created in the first region
-- please see above
-- I then created a dynamic action on region 1->Item global_dept
Fire when Event result is true
Select type Region
-- basically every time the user change the value of global_dept I want to
-- refresh region r2 which is base on a select stmt that reference the dept.
Basically I want a select list where the user can select the dept they want to access
and underneath it is a selection of all emp where dept = selected dept.
Sample Screen Layout
Edited by: kvsinfo on Jan 8, 2013 2:09 PM
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.
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.