APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

 

Compete in the ODTUG APEX   Plugin Competition!

·   Rules on ODTUG

·   Register to submit

·   Winner will be announced at Kscope12!

 

Basic Competition Rules

  • Only new plugins can enter the competition
  • Plug-ins must be submitted by May14,2012
  • Select ODTUG Competition as category
  • Provide an URL to a demo location
  • Source code uploaded to ODTUG Competition category is not downloadable during competition

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

10
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  

Keywords
lov, super, skillbuilders

Company: SkillBuilders
Date added: 17.12.2010
Views: 11754
Votes: 26
Reviews: 82
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
Download
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.
10 
Thanks - Searching on more than 1 word /
by Pete Mahon
on May 17, 2012
Appreciated Dan, thank you. It looked like a Oracle package restriction alright but wanted to double check. Seeing as we're not *supposed* to know how wrapped packages work!

Cheers, Pete
0 
Searching on more than 1 word / wildcard
by Dan McGhan
on May 9, 2012
Hi Pete,

The plug-in uses the APEX_PLUGIN_UTIL package for the SQL processing. That package doesn't support searching all columns which is why the plug-in doesn't.

It is on the list of enhancements but there's no telling when I'll have time to get to it.

Regards,
Dan
0 
Searching on more than 1 word / wildcard
by Pete Mahon
on May 9, 2012
Hi Dan,

I searched for a solution to this and haven't seen one yet... a comment from a year ago asked if you were going to implement a fix so that the Super LOV would allow searching with % wildcard and two search terms with spaces, i.e.
John Jones
John%Jones

I assumed this wasn't working because of the SQL escape mechanism but is this still on the dev list? It's something my customers are asking for.

Thanks in advance.

Kind Regards, Pete
10 
Dynamic action
by Josip Poljak
on April 24, 2012
Hi Dan!

Thanks for your response. The thing is that I set all other items by a sql query, but I'll manage to combine the two approaches.

Thanks,
Josip
0 
Dynamic Action
by Dan McGhan
on April 23, 2012
Josip,

Use the Execute JavaScript action and then $s to set the value. Here's an example:

$s('PX_ITEM_NAME', 101, 'Display Value');

Regards,
Dan
10 
Dynamic action
by Josip Poljak
on April 23, 2012
Hi!
Is it possible to set SuperLOV item through PL/SQL dynamic action?

Thanks!
Josip
0 
Hiding or disabling
by Josip Poljak
on March 16, 2012
Hi,
when I disable or hide an item with this plugin, the buttons are enabled. Is there a way to disable/hide the buttons as well?

Thanks!
Josip
March 7, 2012
The Entry has been updated in the meantime!
0 
Not Compatible
by Dan McGhan
on January 30, 2012
Hi Jon and Benjamin,

I wanted to port the new release, Super LOV 2.0, to APEX 4.0 but we've been having some issues due to jQuery version changes so that may never happen.

Because of this I'll work on getting the previous version, Super LOV 1.3, available for download on our site, but in the mean time please email me and I'll send you a copy.

You can email the address found in the documentation or look for my email on my blog at danielmcghan.us.

Please keep in mind that I will not be addressing any issues with the previous version.

Regards,
Dan
0 
Not Compatible
by Jon Reed
on January 26, 2012
I tried it apex.oracle.com. It worked perfectly. great plugin!!! Went to our environment (4.0.2) and I get the "NOT COMPATIBLE" message when installing. So I presume this plugin should be changed to be 4.1 compatible, and not 4.0 compatible.

Is the pre-December 17th version available?

Thanks. Again, great plugin!
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.