How to change Select List values based on other Select List value using oracle apex?

Question

I have two select lists in my page, Region and Country.

Country should display values based on the value selected from the Region list. But the problem is, it's displaying blank in the Country list, even after selecting a value from the Region list.

 Region table                              Country table

 Id                                        Group_Id
 Name                                      Name
                                           Id

For Region, I have written the query as follows:

Select Name d,Id r from Regions

The query for Country as:

Select Name d,Id r from Country where Group_Id = :P3_REGION

enter image description here

How can I get the correct values?

User42 · Accepted Answer · 2016-07-20 11:21:20Z

2

P3_REGION should be entered as Cascading LOV Parent Item(s) of the Country SelectList.

answered Jul 20, 2016 at 11:21

User42

9631 gold badge16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to change Select List values based on other Select List value using oracle apex?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related