..the apex plugin directory

an initiative of

Add your APEX4.0 Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your website or blog.

You are here:
Follow us on Twitter
Item Plugin SkillBuilders Super LOV

SkillBuilders Super LOV

Categories: Item Plugin
Author: Dan McGhan

Popup LOVs with a web 2.0 twist

The built-in Popup LOV item in APEX can be a powerful tool when the number of possible selections is too high for other item types that use LOVs, such as a select list. However, people often wish to display more information when making a selection than this item type allows. In the past, developers worked around this issue by either concatenating values in the display column or by creating a custom solution.

Custom solutions provided the ultimate flexibility but required a lot of knowledge and were not always easily transferable to other items, pages, or applications. The SkillBuilders Super LOV plug-in is designed to make these issues a thing of the past while providing a rich, web 2.0 experience.

Features at a Glance

Multiple column LOV support

  • Displays multiple columns when LOV is open
  • Column level selection and searching when LOV open
  • Allows for selection of a display column and a return column

Rich client-side user interface

  • Skinned with jQuery UI themes  (currently 25 themes to choose from)
  • Uses a modal dialog over a traditional popup window
  • Select from a variety of loading images, or use your own  

lov, super, skillbuilders

Company: SkillBuilders
Date added: 17.12.2010
Views: 28344
Votes: 42
Reviews: 107
Min. APEX Version:
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
Using Super LOV plugin with Modal page
by Jeremy Webb
on September 3, 2014
I am trying to use this super LOV plugin in conjunction with the modal page plugin.

Is there a way to get the modal page plugin to resize if the super LOV plugin is too large for it?

Currently it just does not display all of the LOV plugin.


Excellent plugin!
by Ime Prezime
on May 6, 2014
Thank you!
What should be source of Display Item
by Vipul Patel
on July 16, 2013
I am using Super LOV with mapped column

Item name P13_ID which is of type super lov
Page 13 also item P13_desc which is display item.

Super love work greate but I wanted to find what should be source used and source type for this Display item.
I wanted to populate desc when page load with value set in id filed
LOV button not displaying properly
by Prasanta
on July 2, 2013

the LOV open dialog and clear content button are not displaying properly in modal, show and hide region template. Also if you use jquery tabs it has the same problem. I check the item style and found it is reducing the height to 9.89px instant of 25px in other template

thanks PP
Minor issue
by Dan McGhan
on January 8, 2013
Hi Vipul,

Thanks for the heads up, we'll look into these when making the next round of enhancements.

Minor issue
by Vipul Patel
on January 7, 2013
I am facing minor issue with hidden column
in code below line
l_hidden_cols := REPLACE(l_hidden_cols, ',' || l_display_col_num || ',', '');

should be change to
l_hidden_cols := REPLACE(l_hidden_cols, ',' || l_display_col_num || ',', ',');

basically repalce comma dispalyvalue comma with comma not space.

Great Plugin. I am also trying to display this lov as Tree if I add spaces or &nbps; or   to my dispaly column this plug in does not display them propely. I have to remove all sys.htf.escape_sc replace with null in plug in
Thanks Dan
by Trish
on December 7, 2012
Thank you Dan , I will try adding the jQuery and changing the theme.
Awesome plug-in by the way !!

Kind regards,
try 3
by Dan McGhan
on November 23, 2012
link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.14/themes/start/jquery-ui.css" type="text/css" /

Just add the less than and greater than to the ends.
Try 2
by Dan McGhan
on November 23, 2012
modifying the theme for this plugin
by Dan McGhan
on November 23, 2012
Hi Trish,

This is harder than it used to be because jQuery UI themes are no longer included with APEX. This means you must include them. You can download your own files and upload them to you listener or you could use hosted files like those from Google. Make sure to use the correct version as it can vary depending on the APEX version.

Then just add the CSS include to your template or page. Make sure it's in the right place with regards to other CSS files. Here's an example, not sure if I can get it right here though.

<link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.14/themes/start/jquery-ui.css" type="text/css" />

Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.