ORacle APEX Global variables (Application items)
Folks,
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
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
could you create a mini app, just 2 pages with one application item, export it and post the sql here to demonstrate what you're doing and seeing?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
worked through the options to come to this conclusion