Solved

ORacle APEX Global variables (Application items)

Posted on 2014-03-27
3
3,220 Views
Last Modified: 2014-04-07
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
0
Comment
Question by:wspall
  • 2
3 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 39961456
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?
0
 

Accepted Solution

by:
wspall earned 0 total points
ID: 39973801
tried numerous dynamic actions/processes to set this "global" values each timwe the page items changed, but to no avail. it may have had something to do with using the Big Value List plugin needing the page submitted every time to refresh it (again dynamic action didn't seem to work on this one)..

So ended up just adding the items as hidden items on the report page and passing the parameters in the URL to that page to drive the report. means I can still do this from any other page, I just seem to recall global variables being a lot easier once upon a time !!
0
 

Author Closing Comment

by:wspall
ID: 39982571
worked through the options to come to this conclusion
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Clone Oracle 12c Database 5 42
SQL Retrieve Values 4 55
execute immediate plsql block 5 33
Export table into csv file in oracle 10 41
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

939 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now