Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select2 plugin setting default value issue

Sridhar EswarasamyJul 27 2017 — edited Jul 27 2017

Hi,

Am using the select2 plugin (Version 5.0.4.00.12), My requirement is to display the values of check box to Select2 plugin dynamically when ever I click on the check box,

Example

Check box 1 - "Red"

Check box 2 - "Blue"

Check box 3 - "Yellow"

When I click on check box 1, value should display in select2 plugin like

Select2 plug in -  "Red"

When I click on check box 2, value should display in select2 plugin like

Select2 plug in -  "Red" "Blue"

When I click on check box 3, value should display in select2 plugin like

Select2 plug in -  "Red" "Blue" "Green"

I am created a dynamic action to store the values in table named as "test", value are stored properly in table, later am created another dynamic action(plsql event) to move the table data to the text item :P4_FILTER_TEXT as like mentioned below, values are displayed properly with colon separator.

Begin

SELECT LISTAGG(upper(col1), ':') WITHIN GROUP (ORDER BY col1)  into

:P4_FILTER_TEXT

      FROM  test;

end;

Now am created another dynamic action to move the text item values into Select2 plug in named as :P4_FILTER_NAME as like mentioned below,

Begin

:P4_FILTER_NAME:=:P4_FILTER_TEXT;

end;

Now when I click on check box 1 value displaying properly like

Select2 plug in -  "Red"

but when I click on check box 2 value is getting disappeared, but I can see all three values in LOV. As I observed values are getting concatenated and it is not matching with LOV value, I need a code to append the value to select 2 plug in. please let me know how to achieve this

Thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2017
Added on Jul 27 2017
0 comments
424 views