Creating Multi-Column Popup LOV in Oracle Apex 19.2

First of all, there is good news, that Oracle Apex 19.2 has been released on 1st November 2019 and it is available for download now. In my previous tutorials, I have given examples of how to create a faceted search and star rating items in Oracle Apex 19.2. And in this tutorial, you will learn how to create multi-column Popup LOV in Oracle Apex 19.2. Follow these steps:

Steps to Create Multi-Column Popup LOV in Oracle Apex 19.2

1. In Oracle Apex, click on the Shared Components > List of Values and then click the Create button. The following window will appear:

Multi-column popup LOV - step - 1

2. Simply click on the Next button and the following window will appear. Specify the LOV name here, then click on the Next button.

Specify LOV name.

3. In the next step, select the table or specify the SQL query. But remember, your SQL query should have a maximum of 2 columns, one is for display and one is to return. And don't worry, in the next steps I will show you how to add multiple columns to this Popup LOV. After that click on the Next button.

Select a table.

4. In the following screen, define the return column and display column and then click on the Create button.

Select a Column to display.

5. You have created the Popup LOV in Oracle Apex, but it will currently show only one column, to convert it to multi-column LOV, you need to edit this LOV. To edit the LOV Products, we just created, click on the Shared Components > List of Values and then click on the Products LOV. Then scroll down the window and in the Source section, click on the button next to Additional Display Columns as shown in the below image:

Define multiple columns for LOV.

Here you can select multiple columns to display and then click on the Update button. After that click on the Apply Changes button.

6. Now there is a need to assign this Popup LOV to an item in Oracle Apex. To do this, open your page and select the item for which you want to show the LOV and change its type to Popup LOV and set the following properties shown in the image below:

Oracle Apex Multi-Column Popup LOV settings.

 

You can specify the settings according to your choice. Now save the changes and run the page to test. You will the output as shown in the below image:

Oracle Apex 19.2 - Multi-column Popup LOV example.

Related tutorials:

Vinish Kapoor
Vinish Kapoor

Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.