POP up LOV Enhancements in APEX 19.2

How to display multiple columns in APEX POP UP LOV?

Preview

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

Preview

Preview Preview

Let’s try to add other columns

Preview

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 ;

Preview

  • Define Column Mapping

    • Display Column
    • Return Column Preview
  • Additional Display Columns

    • Select the desired columns to display Preview
  • Go to Page Item

  • Select the list of values from shared components Preview Preview Changing Dialog Title Preview Preview

  • 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 Preview Preview Preview Preview

Other Tips

If you have any column index which can improve search through POP UP LOV, then select Oracle Text Column.

Preview Download Sample application


comments powered by Disqus