SkillBuilders Super LOV Tweet
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.
Rich client-side user interface
lov, super, skillbuilders
Do you have a question about this Plugin? Want to write a Review or Comment?
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
Thanks for the heads up, we'll look into these when making the next round of enhancements.
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
Awesome plug-in by the way !!
Just add the less than and greater than to the ends.
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" />
How can you modify your theme in Apex for this plugin?
that's real Forms functionality, great!
Popup LOVs and select lists are different in that the values for the select list are already on the page. That's why one works and the other doesn't.
A better comparison would be Super LOV to the Popup LOV. You test will not work for either. However, we've added methods to Super LOV to allow you to do these things provided you put in the effort.
Try using the setValuesByReturn method which is covered in the documentation (although there's not much there). Just follow the example and set using the return value and it will look it up against the LOV. If it finds a match it will set the display and return values in the item, if not then neither the display or return is set.
I have 2 'super LOV's' that should act cascading.
After I select a value from the first super LOV a dynamic action is fired to resolve/calulate the value for the second LOV, but this values is not shown.
If I change the second super LOV to itemtype Select List the calculated value is however shown, so the dynamic action does work. Changing the itemtype back to super lov (enterable - not restricted) no calculated value is shown.
How could I show the calcuated value in the second super LOV?
I am on Application Express 4.1.0.00.32 and using your plugin 2.0.2
|Powered by Sigsiu.NET|