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.

 

One thought on “APEX Popup LOV with more columns”

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>