APEX Plugin Super LOV for Tabular Form

For an actual Application Express project I needed a way to choose a value from a modal dialog for a field in a page. Normally I could use the build in LOV or a simple object but the problem is that the user needs to see more than one value of a data row. I don’t want to talk about the project but if u image u have a customer who operates a supermarket chain. So every store of the chain has the same name. Imagine the user of the application has to choose one of the stores out of a list of all available stores to deliver some products. Obviously the user needs to see additional attributes (e.g. city, zip code…) to choose the right store. I was lucky because I found a pretty plugin called Super LOV. This plugin allows you to open a modal dialog for that need for a PAGE ITEM only.

In my case it was necessary to use it within a tabular form. So after some hacking and extending I know my solution is not the cleanest (because I’m using the old object to trigger the necessary dialog) but it is working smooth.

Just create a PAGE_ITEM as a plugin type of this plugin (the page item will not be visible) and configure it as described. Additionally create a tabular form with a LOV column. Now edit the page item and set the Tabular Form LOV Column as seen in the pictures.

Try to click now on the LOV button in the report column and the modal dialog will appear instead of the standard LOV.

You can download the plugin here: at_nethead_tabular_form_super_lov

Update[03rd Oct. 2011]:

Unfortunatly I forgot to post the link to the original creators of the Super LOV Plugin. For the major work of the plugin the credits go to Skillbuilders. Thanks for your work and thanks for releasing it under GPL & MIT license.

Tweet