APEX-PLUGIN.COM

..the apex plugin directory

an initiative of
 

Latest Plugins

 

Top Rated Plugins

Context(rightclick) Menu (4.9)10
Combobox (4.8)10
SkillBuilders Super LOV (4.8)10
(IR) Report to Excel (xlsx) (4.8)10
DTreeTable (4.8)10

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
Company: NESCO Solutions GmbH
Date added: 31.12.2010
Views: 9472
Votes: 9
Reviews: 21
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
Highslide JS
Demo EMP-Filter
Highslide JS
Demo V1.0.3
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: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
0 
Insert Return Value into Page Item
by Thor
on March 18, 2013
Hi,
just one Question. How do i get the values stored in this page item? I am creating a workflow and the values seen should be stored in my query. Thx in advance.
0 
New release 1.4.0 for APEX 4.2.1
by Volker Paul
on March 5, 2013
New release 1.4.0 for APEX 4.2.1 is now available for download.
March 5, 2013
The Entry has been updated in the meantime!
0 
RE: It doen't work fine in apex 4.1 or
by Volker Paul
on March 4, 2013
Hello Asif,
please download the latest release from here
http://www.nesco-solutions.de/download/apex_plugins_multiselect-4.1-48.zip
and try again. I check it with APEX 4.2.1 and it works.

Regards
Volker
0 
It doen't work fine in apex 4.1 or above
by ASIF MOHAMMED
on March 4, 2013
hi,
I am using apex 4.1.1, but the problem is
when i checked the All, the checboxes in the list not get checked, i have to checked one by one in apex 4.1.1 or apex 4.2
0 
AW: Rename checkbox All to "Alle"
by Volker Paul
on February 26, 2013
Hello Thorsten,
yes, there is.
There are 2 ways to change the label "All".

1. Changing the "All" label for all checkbox-items in your application:
Go to Shared components -> Plug-ins and edit the PlugIn: Multi-Select-Checkbox-List. In PL/SQL Code search the string "Alle
2. Changing the "All"-Label for a specific item:
Find out the object-id of the "All"-Label you want change (with Firebug).
Create a dynamic action on Page-Load, create a True-Action of type "Execute Javascript code" and write a JQuery Scriptlet like this:
$('#fs_P1_DEPT > label').text("changed").

Good luck
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.