Tuesday, 28 December 2010

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.

APEX 4.0.2 is installed

OK Guys,

APEX 4.0.2 has been installed without any trouble. just follow the instructions provided by Oracle.

Friday, 24 December 2010