Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 439 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
APEX Popup LOV - Conditional Select

Hey, complete newbie here.
I'm wanting a form that inserts rows into a central table 'Action Plan' from various category-specific tables/pages, each with their own unique reference IDs. Key items in the form:
- Reference (listing the source reference ID)
- Source (passing static value based on link-to-form source)
The form is built on the Action Plan table. I want the reference field in the form as a Popup LOV conditional against the source.
Use case:
- user is working in 'Area 1 IG' and wants to insert 'Action Plan' to central table
- button in 'Area 1' page links to 'Action Plan' form with static value passing to 'Source' field in form
- 'Reference' field on form presents list of values as 'Area 1 IG' 'Reference Column' to select
I hope this makes sense, and I have a feeling it's a really simple answer. I'm extremely new to APEX and SQL in general.
Thank you
Best Answer
-
If I understand it correctly, you just want to make an LOV conditional on a page item which has a value passed to it from another page. If it is just that it should be simple enough. Include the source item in the "where" clause of your LOV query - for example. "where source = :P1_SOURCE".
In the "Cascading List of Values" section of the LOV item, select the source item (P1_SOURCE or whatever) in the Parent Item(s). If the source item only ever changes when the page is called from one of the "category" tables, it may not be necessary to do this, but basically it guarantees that when ever the "source" changes the LOV will be refreshed.
If there is more to it than that, please let me know and I will try to help.
Answers
-
This thread was posted in the SQL and PL/SQL space. There' a separate space for Apex issues:
I'll try to move the thread for you.
-
Ahh, thank you. I'll move it, appreciate the response.
-
If I understand it correctly, you just want to make an LOV conditional on a page item which has a value passed to it from another page. If it is just that it should be simple enough. Include the source item in the "where" clause of your LOV query - for example. "where source = :P1_SOURCE".
In the "Cascading List of Values" section of the LOV item, select the source item (P1_SOURCE or whatever) in the Parent Item(s). If the source item only ever changes when the page is called from one of the "category" tables, it may not be necessary to do this, but basically it guarantees that when ever the "source" changes the LOV will be refreshed.
If there is more to it than that, please let me know and I will try to help.
-
I Have a LOV called GROUPS and another LOV called SUBGROUPS. How could I make a reference in the second LOV to a value selected on the first LOV? I mean some like where SG_GROUP=:GR_GROUP doesn’t work :(
-
Are you talking strictly about LOV as a shared component? I do not believe you can include a parent_id column within LOV to create that relationship between these two lists.
Are the LOVs dynamic, and, if so, how have you defined a SUBGROUP belonging to a GROUP?
-
Thank you I have resolved
I was using a Table as Source Type. Now with SQL Query as Source Type the filter works fine
thank you for your help and attention Please have a nice day :)
JAC
-
Sounds good, take care.