• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2672
  • Last Modified:

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

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.
  • 2
1 Solution
what is the question?  Which part of that do you need help with?
pattisp1Author Commented:
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.      
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now