APEX-PLUGIN.COM

..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 Multi-Select Checkbox-List

Multi-Select Checkbox-List

10
Categories: Item Plugin
Author: Volker Paul

A multiple select-list with Checkboxes

This multi-select list is an easy-to-use solution for special Filter-Items in Reports.
You can enable or disable all list-values with 1 click, add cascading LOV Feature and enable an additional Pre-Search Option to Filter the displayed Values.

 

New Features (V1.0.3)

Cascading LOV Feature now available

The cascading LOV Feature is now available.

Pre-Search Option available

The Pre-Search Option means an additional Filter-Item to filter the visible values.

 

Solution
This PlugIn renders a fieldset with an "All"-Selector, a Hidden-Item to store the return result and a div-Region with all LOVs as Checkboxes.
The return-value is a concatinated string delimited by a special seperator (in this case a ":"). The seperator can be changed in the item-settings region. So the result-string is something like this:

ANALYST:CLERK:MANAGER

or if you use IDs:

10:13:17:21

 To handle such value string please have a look below to the requirements section.

 

Limitations

The List of return-values should not be greater than 4000 characters. Reason is the 4000 character limitation of Oracle VARCHAR2 Objects in APEX.

 

The download file includes the old Release 1.0 and the current Release 1.0.3 with the Cascading LOV Feature and the Pre-Search Option.

Special Requirements
There are no requirements for this Plugin.
But multi-select-lists like this return multiple values. Such multiple value strings must be handled.
You can find a solution at my Demo-page on
http://apex.oracle.com/pls/apex/f?p=39514:2

Keywords
multiple select list apex 4.0 plugin multi checkbox liste code wiederverwenden modularisieren erweitern

Demo EMP-Filter
Demo EMP-Filter
Date added: 31.12.2010
Views: 18427
Votes: 11
Reviews: 27
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.
0 
RE: Plugin broke in IE
by Volker Paul
on April 8, 2014
Hello Kiem,
which version of IE are you using? I check it out with IE9 and it works fine. I know, that older IE-Releases had a lot of problems with HTML-Standards and some JS-Functions. So I recommend to use newer releases of IE.

Kind regards
Volker
0 
Plugin broke in IE
by Kiem Nguyen
on April 7, 2014
Dear Mr. Paul, thanks for a great plugin. I'm using APEX 4.1 and upgraded to latest version of JQuery. The plugin works fine in Chrome and Firefox but it doesn't display correctly in IE. I wonder if you could help me with this. Thank you and I greatly appreciate your help.
0 
RE: Plugin css/html ...
by Volker Paul
on February 9, 2014
Hello Johnson,
thank you for you feedback.
Please have a look at my demo. You'll see that the MSCB-Listitem "Manager" doesn't have a pane below the All-Selector (for a better understanding: this pane is an item to filter the content of your list-values!)..
OK, at my demo page please look for the explanation of "Enabling Pre-Search Option". With this option you can enable/disable this pane.

"Alle"-Label
If you want to change this label, create a dynamic action for Event "Page Load". Create a TRUE-Action on "Execute JavaScript Code" and Code like this:
$('#fs_YOUR_ITEM_NAME > label').text("New Label");
That's it.

To change css and HTML go to Apex Builder - your MSCB-Item and have a look at the section "Settings". There you'll find some options to control the styles of your MSCB-Item.
If you want to change the HTML you should use JQuery to change it.

How it helps.
Regards
Volker
0 
Plugin css/html pane delete
by Johnson
on February 6, 2014
Hi Volker,
Thanks for the plugin ,it solved our application issue ,it is very useful to us.I just translate this Label of 'Alle' to Englishi version 'Select All'
there still one thing I need rewrite this plugin .to delete the pane under Select All ,if you can proved me how to change some css/html at this plugin ,that will be great .
kindly wish you reply me, I will sent you the details issue .

BR/Johnson
0 
Terms of use
by Jay Hartford
on December 2, 2013
Hello,

I was wondering where I could find an English version of the terms of use.
10 
Thanks for the plugin
by msubashreddy
on August 4, 2013
Thanks for the plugin
0 
Re:RE:RE Insert Return Value into Page I
by Volker Paul
on March 19, 2013
Hi Thorsten,
I'm not sure if I have the right understanding of your problem.
Please have a look at my demo once more. I've created 2 new Items that shows the return values of Manager- and Job-Filter and it works fine. After you select or de-select Managers or Jobs you have to press "Apply Filter" to see the new value.
Another way is to check session-values for this items with the apex-dev-toolbar - press "Session" and check the session values.
Or set DEBUG-Mode to YES. This renders additional Buttons for every Checkbox Item called "Get checkbox values". If you press this button an alert will show you the return value of you multi-CB Item.

Please try this and let me know if everything's ok.
Good luck.
10 
by Thorsten1981
on March 19, 2013
firebug:

input type="hidden" value="11268673919332894388" name="p_arg_names">
input id="P2_MANAGER_FILTER" type="hidden" value="7782:7934:7947:7521" name="p_t02"
0 
RE:RE Insert Return Value into Page Item
by Thorsten1981
on March 19, 2013
Hi Volker,

I still didnt get it. If I watch your Demo and choose all managers I see the following in firebug:




So this seems to be stored. But I need to write into a seperate Item.

If I create an Item :
Select :P2_MANAGER_FILTER from dual
it will not show anything.

And If i try:
select 1 from table (parse_ms_valuelist_to_sql(:P2_MANAGER_FILTER))

Greetings Thorsten
there is still no result. I hope you can help.

I still dont see a result.
0 
Re: Insert Return Value into Page item
by Volker Paul
on March 18, 2013
Hi Thor,
please have a look at my Demo
http://apex.oracle.com/pls/apex/f?p=39514:2
and follow the instructions under the "Usage"-Section at the right side of the demo-page. This should give you the answer.
Kind regards
Volker
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.