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, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Item Plugin Multi-Select Checkbox-List

Multi-Select Checkbox-List

9
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: 25730
Votes: 16
Reviews: 36
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.
4 
more issues
by Chester J Szatkowski
on October 23, 2016
What is the name of the Hidden Page Item intended to receive the colon delimited list of selected values? I do not see that it was created anywhere on the page that contains the plug-in.
0 
Issue with Select ALL
by Chester J Szatkowski
on October 23, 2016
Application Express 5.0.3.00.03

The Alle is not working.

The Initial page load has ALL items checked.

I can uncheck individual item and the ALL item becomes unchecked which makes sense, but then when I re-check the Alle item a the top it actually deselects all of the checkboxes for all of the items. It never "checks" them all.
0 
Issue with Select ALL
by Chester J Szatkowski
on October 23, 2016
Application Express 5.0.3.00.03

The Alle is not working.

The Initial page load has ALL items checked.

I can uncheck individual item and the ALL item becomes unchecked which makes sense, but then when I re-check the Alle item a the top it actually deselects all of the checkboxes for all of the items. It never "checks" them all.
0 
by Chester J Szatkowski
on October 23, 2016
Application Express 5.0.3.00.03

The Alle is not working.

The Initial page load has ALL items checked.

I can uncheck individual item and the ALL item becomes unchecked which makes sense, but then when I re-check the Alle item a the top it actually deselects all of the checkboxes for all of the items. It never "checks" them all.
0 
Re: Cascading LOV not working
by Volker Paul
on August 18, 2015
Hello Senthil,
please have a look at my demo. This application have been upgraded by oracle and it works without any changes.
Can you give me more input? Have you checked for JS-Errors?
Regards
Volker
0 
Apex 5
by Senthil Kumaran. S
on August 18, 2015
We are having Apex5. Cascading LOV is not working. Can you guide me how I can use the same in APEX 5.0
0 
RE: Search using Pre-Search Option
by Volker Paul
on April 15, 2015
Hello Vijay,
sorry for the delay.
Well, enabling pre-search-option is very simple.
Please go to Plugin-Item Page and look for the property "Enable Pre-Search Option" and set the value to "Yes".
That's it.

Regards
Volker
8 
Add Setting
by Eric Joppru
on March 25, 2015
Thanks for this plug-in -- I've just downloading it and have implemented it successfully into a business application. If possible, it would be nice to have the Settings option for Page Action When Value Changed similar to some of the out of the box items. For example, I could submit the page when a user makes a change to this multi-select. This would save a user having to make a change to the multi-select and then press a Submit button. Thanks again for the plug-in! -Eric
10 
Search using Pre-Search Option
by vijay
on March 18, 2015
Hi Paul, I want to filter the checkbox values using pre-search option.

I should be able to search for the checkbox values starting with string entered in the textbox.

If I type 'A' in the textbox.. It should return only the values starting with A. (Analyst)

Please let me know how to achieve this.

Regards,
Vijay
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
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.