How to display multiple columns in APEX POP UP LOV?
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-177.png)
Legacy APEX POP UP LOV generally has one display column and one return column. What if we need to display more information to the user to search on.
APEX Version : APEX 19.2
- Create a POP-UP LOV item.
Item Query:
select ename as d,
empno as r
from emp
order by 1
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-176.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-175-1024x474.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-174.png)
Let’s try to add other columns
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-173.png)
So, we cannot add more than two columns while the List of values Type is SQL Query.
Now try with the Shared component.
List of Values
- Type: Shared Component
- List of Values: List from shared component
Create List of values entry in Shared Components
- Go to Shared Components
- List of Values
- Click on Create List of values
- Name it
- Put your SQL query like below
Select ename,
Deptno,
sal,
hiredate,
empno
from emp ;
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-172.png)
Define Column Mapping
- Display Column
- Return Column
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-171.png)
- Additional Display Columns
- Select the desired columns to display
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-170.png)
- Go to Page Item
- Select the list of values from shared components
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-169.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-168.png)
- Changing Dialog Title
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-167.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-166.png)
- Adding Icons to display column To add display icons in with display column try below query to LIST of Values entry
SELECT ename,
deptno,
sal,
hiredate,
empno,
'fa fa-user' icon
FROM emp;
Setup icon in Column Mapping
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-165.png)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/icon-selection.gif)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-164.png)
Other Tips
If you have any column index which can improve search through POP UP LOV, then select Oracle Text Column.
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-163.png)
Download Sample application