APEX Popup LOV with more columns

Today I found a really neat plug-in to Oracle’s APEX.

Have a look here: http://www.apex-plugin.com/oracle-apex-plugins/item-plugin/skillbuilders-super-lov_75.html

All’s well, ut there is a downside to using this plug-in. Cascading Parent LOV’s are not supported yet. I hope they will soon. So I came up with an alternative that does use the native popup LOV.

  • I altered the template that displays the LOV to use a fixed with font for the body
  • I use LPAD and RPAD in combination with ‘ | ‘ to neatly outline the columns

the result looks like this:

Maybe is not the most beautiful solution, but it suffices for now.

 

Leave a Comment