Discussion on "APEX Popup LOV Deep Dive"

Jon Dixon · 2022-12-01T14:08:35.497Z

Introduction This post will deep dive into the APEX Popup LOV item type. Much like a Select List, the Popup LOV allows you to present users with a list of items to select from. The Popup LOV takes list selection further by offering these additional f...

Improvement 2: Ability to pass in parameters from the calling page.

Jon Dixon You could use Source Type = "Function Returning SQL" instead of a SQL Query.

return lov.get_emp_list ('P' || :APP_PAGE_ID || '_DEPT_ID');"

Thanks for the idea Jochen. That would work. I was just trying to nudge Oracle into adding the ability to do this declaratively :)

Hello. Thanks! Your post was really helpful!

I have a question. In my application there is LOV item with the option 'Search as you type' selected. I have a button (disabled) to add a new entry, I would like this button to be enable when the result of the search returns no value. I've tried with JS and with DA, but I couldn't achieve this behavior. Do you have any idea how can I do that?

Hi, glad you liked the blog. Sorry, I am not sure how you would trigger an action when the result of the search is empty (while the Popup LOV is open).

It's OK Jon Dixon Thanks anyway and congratulations for the great content you provided :)

How to add a new value to the table if the value is not exist?

Not easily. You could add a button near the Popup LOV field called something like 'Add New Values', which has a Dynamic Action. The Dynamic Action takes selected values from the Popup LOV field and checks them against the table, adding new values to the table.

Search Hashnode

APEX Popup LOV Deep Dive

Responses3