Solved

Oracle Apex How to set up Select list with submit page item

Posted on 2008-10-23
3
2,542 Views
Last Modified: 2013-12-07
I have an existing page that displays data for one location.   I need to revamp things and add multiple locations that will be in a select list with submit. so that when a location is chosen the page is resubmitted with the location chosens data.   All the queries are in pl/sql on an oracle database.  

Thank you.
0
Comment
Question by:pattisp1
  • 2
3 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 22789298
what is the question?  Which part of that do you need help with?
0
 

Author Comment

by:pattisp1
ID: 22799772
I am going from a static location of Michigan and we are adding another location in Indiana.   The default information on the page will be for Michigan.   I want the ability to pull down the drop down list for location and when I chose Indiana, the page is automatically refreshed with the data for the Indiana location.  I have the drop down already as a select list with submit but now I need to repopulate the data with the Indiana location chosen.   The data will be stored in an Oracle table.      
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 250 total points
ID: 22799811
how does your page know how to pull Michigan data?

I assume your report and chart regions have queries something like this?


select col1,col2, col3 from your_table where state_name = 'Michigan'

change that to

select col1,col2, col3 from your_table where state_name = :P20_STATE_CHOICE


where P20_STATE_CHOICE is the name of your select list item
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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.

864 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

20 Experts available now in Live!

Get 1:1 Help Now