ORacle APEX Global variables (Application items)
Posted on 2014-03-27
I must be missing something simple here, but obviously need a push in the right direction!
I have an APEX application with a fairly simple table behind it which lists the total number of "events" for a number of different locations. Event totals are displayed by location, date & session. On page one these are 3 page items for the users to change.
Clicking on a returned event total will display a second page listing all the individual events that make up that total (ie a simple drill down)
I also want to use this second page to provide the drill down for some charts etc which will live on another page (eg 3). Currently my drill down references page 1 items in the query.. I thought right let me replace these with "GLOBAL" variables and then doesn't matter what page I come from as long as I update the global variable's values the drill down will yield the right result !
Well doesn't matter if I create dynamic actions with PL/SQL to change these GLOBAL variables individually or on masse, or add it to page processing, I'm just not seeing these varilables change value.
I do use a submit after changing one of the 3 page items to refresh the Totals report, but I really can't see where else I'm going wrong !
any suggestions would be greatly appreciated !!
thanks in advance