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 Combobox With Custom Display

Combobox With Custom Display

10
Categories: Item Plugin
Author: vikram

Add HTML tags and Images to the dropdown

Combobox (searchable select list) is a great replacement to the standard select list and autocomplete. It removes the limitation of APEX autocomplete item which can have only one column for display and return. This is easy to configure and easy to use that enables you to add a new value to the drop down list on the fly.

A case in-sensitive search is performed with the entered value for both Lazy Loading and Non Lazy Load. 

Plugin options:

Lazy Loading:  If set to yes, the matching values will be read from the database each time the user types a character. If set to no, all values will be read only once when the page is rendered..

Allow Add New: Chose yes if you want to allow the user to add new values to the list using below PL/SQL Block (Only Available if Lazy Loading is set to Yes)

PL/SQL Code for Add New: Enter the PL/SQL Function Body to populate the new value into database table returning its ID (Only Available if Allow Add New is set to Yes)

Set Value of Combobox Using below syntax:

$('#PX_ITEM_NAME').vcCombobox2('SetValue',<<VALUE>>);

For Example:

$('#P4_TEST').vcCombobox2('SetValue',9999);


Keywords
Combobox,plugin,custom display

#1
#1
Company:
Date added: 22.5.2012
Views: 8183
Votes: 9
Reviews: 14
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
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.
10 
Match Type
by Matt
on November 17, 2013
Is their a way to make it MATCH on the search...For example,

VALUE = 'SMI' would return

SMITH, JOHN

but would not return

SAMSMI, JOHN

so it is a VALUE% not %VALUE% ?? Thxs
0 
Having trouble logging into demo
by Scott
on October 21, 2013
test/test not working!
0 
Correction double quote
by Baki
on April 24, 2013
In my previous post under 2. shold be

2. if display data contains double quote, they replaced with & quot ; and after selection remains in combo box field

thx
Baki
0 
Double quotes "
by Baki
on April 24, 2013
Hi Vikram,

Your plugin is great and I wish to use it in my applications. I've noticed couple issues about double quotes .
1. If search term contains double quote, in chrome developer tools reports error: Uncaught SyntaxError: Unexpected string
2. if display data contains double quote, they replaced with " and after selection remains in combo box field

Thanks
Baki
0 
Scroll issue
by Hrvoje
on April 18, 2013
Hi Vikram,

I have noticed that scrolling inside 'ul' isn't working. Neither on a test/demo page provided, or in my application. The issue seems to be within apex.vcplugin2-ac.min. Widget "ui.menu" is missing "scrollTop" and "scrollHeight" attributes.And manualy adding them into ui.menu _create method doesn't fix the issue.

If you could review the issue, it would be much appreciated.

tnx,
Hrvoje!
0 
Combo box return value to submit
by Ramani
on March 28, 2013
i have added this Plugin,i want redirect to set value in another region based on this selected return value.same like Apex LOV Rediect and Set Value ...i try the JS it could not work!
my combo box item P9_DEPT
Region:
select DMS_DT_ID from DMS_DEPT_TYPE
where MAS_REF_ID=:P9_DEPT;
Thanx,
RAM
0 
by vikram
on February 8, 2013
Hi Enny,

Yes you have to use following syntax given in the plugin documentation above.

$('#PX_ITEM_NAME').vcCombobox2('SetValue',<>);

Set the dynamic action to Execute JavaScript code and enter

$('#P18_COMBO_BOX').vcCombobox2('SetValue',9999);

Thanks,
Vikram
10 
Re: Refresh combobox
by E. Wong
on February 8, 2013
Ps.

I've also added dynamic action: Set Value.
But still ...
0 
Refresh combobox
by E. Wong
on February 8, 2013
Hi Vikram,

I've created a Dynamic Action (action = Refresh) on an item e.g. P18_EMP. When this item change, the combobox P18_COMBO_BOX should immediately refresh. But this doesn't happen.
I think I'll have to use something with javascript code again? Can you please help me out again please.

Thank you very much,
Enny
10 
Re: Dynamic Action to hide/show Combobox
by E. Wong
on February 7, 2013
Thank you Vikram!
It works fine now.
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.