---
title: "Discussion on \"APEX Popup LOV Deep Dive\" | Hashnode"
description: "Discussion on \"APEX Popup LOV Deep Dive\". Deep Dive into the Oracle APEX Popup LOV item type. Take List of Values selection to the next level."
url: "https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [APEX Popup LOV Deep Dive](https://blog.cloudnueva.com/apex-popup-lov-deep-dive?utm_source=hashnode&utm_medium=feed)

Deep Dive into the Oracle APEX Popup LOV item type. Take List of Values selection to the next level.

Dec 1, 2022 · 10 min read · blog.cloudnueva.com  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#oracle](https://hashnode.com/tag/oracle)

## Written by

[Jon Dixon](https://hashnode.com/@orclapex)

@orclapex · San Diego, CA

  
[View profile](https://hashnode.com/@orclapex)

APEX, ORDS & the Oracle Database

I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.

## Responses 3

Markdown supported · ⌘↵ to post

[Jochen Zehe](https://hashnode.com/@jozzh)

[Jun 15, 2023](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/648ac49e1c2b5dbd4dc8f5b5)

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

[Jon Dixon](https://hashnode.com/@orclapex) You could use Source Type = "Function Returning SQL" instead of a SQL Query.

return lov.get\_emp\_list ('P' || :APP\_PAGE\_ID || '\_DEPT\_ID');"

[Jon Dixon](https://hashnode.com/@orclapex)

[Jun 15, 2023](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/648ac49e1c2b5dbd4dc8f5b5#reply-648b0b2858844acb4aefeab1)

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

[Rodrigo Oliveira dos Santos](https://hashnode.com/@rodrigopoloni)

[Feb 1, 2023](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/63da41af672b295ef3b4294e)

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?

[Jon Dixon](https://hashnode.com/@orclapex)

[Feb 1, 2023](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/63da41af672b295ef3b4294e#reply-63da6d56b7131763ef1ae85d)

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).

[Rodrigo Oliveira dos Santos](https://hashnode.com/@rodrigopoloni)

[Feb 1, 2023](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/63da41af672b295ef3b4294e#reply-63da7cbb4d93226420f662ae)

It's OK [Jon Dixon](https://hashnode.com/@orclapex) Thanks anyway and congratulations for the great content you provided :)

[Mohamed Sameer](https://hashnode.com/@samfaj1255)

[Dec 28, 2022](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/63ac8ca15783d419f05ccc0a)

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

[Jon Dixon](https://hashnode.com/@orclapex)

[Dec 28, 2022](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/63ac8ca15783d419f05ccc0a#reply-63ac8f845783d419f05cccbc)

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.

[Mohamed Sameer](https://hashnode.com/@samfaj1255)

[Dec 28, 2022](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/63ac8ca15783d419f05ccc0a#reply-63aca2a25783d419f05ccfab)

[Jon Dixon](https://hashnode.com/@orclapex) thanks
