Issue using Select Named LOV in Oracle Application Express

Question

I am using Application Express 3.2.1 and I have an application that when run pulls these columns from a database:

Display Name, Email Address, Phone Number, Home Network, Country

I want to make a way to filter the rows by Country, so I created a Select Named LOV with this values definition:

select name d, name v
from 
(
    select distinct(country) name
    from hh_carriers 
)

When I click "Run" for my application, all my data is displayed correctly and my select list populates correctly. However, when I select a "Country" from my select list, the data doesn't change. The select list also goes back to the default value. Is there something else I have to do with the Select Named POV? What do I have to do to make the filter work? Thanks.

This is what my SQL statement looks like to generate my page:

select * from hh_carriers
where
country like :P5_COUNTRY

Display Extra Values: No
Source Used: Only when current value in session state is null
Source Type: Static assignment (value equals source attribute)

Edit: Changed some things for clarity

You will need to add a button to submit the page. On submit, your LOV selected value will be posted for use in your page process. If you want the page to submit on change automatically, you'll need to add a dynamic action or a bit of javascript. — Wolf

Tony Andrews Tony Andrews · Accepted Answer · 2011-09-30T15:32:23

You need to reference the select list in the WHERE clause of the report query something like this:

where home_network = :p123_home_network

(p123_home_network being the name of the select list)

Issue using Select Named LOV in Oracle Application Express

3 Answers