APEX Popup LOV - Conditional Select

alexwintersmithlackey

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

Rick-Pick

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.

Frank Kulash

Hi, @alexwintersmithlackey

This thread was posted in the SQL and PL/SQL space. There' a separate space for Apex issues:

APEX — oracle-tech

I'll try to move the thread for you.

alexwintersmithlackey

Ahh, thank you. I'll move it, appreciate the response.

Rick-Pick

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.

User_OUBNY

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 :(

alexwintersmithlackey

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?

User_OUBNY

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

alexwintersmithlackey

Sounds good, take care.