APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

 

Top Rated Plugins

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

Combobox

10
Categories: Item Plugin
Author: vikram

Overcome Select List & Autocomplete limitations

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 - JavaScript/Jquery:

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

For Example:

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


Keywords
combobox,autocomplete,apex,plugin,combobox add new

Show All Items
Show All Items
Company:
Date added: 15.5.2012
Views: 12925
Votes: 31
Reviews: 84
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.
0 
RE: Double quotes "
by vikram
on August 12, 2013
Hi Baki,

I will have a look into the issue and fix it soon.

Thanks
0 
RE: Specials characters
by vikram
on August 12, 2013
Hi Lucien,

You can achieve that by customizing the plugin code, so its a customization and I don't see it as a standard functionality.

Thanks
0 
Specials characters
by Lucien Aussibal
on August 5, 2013
Hi Vikram,

Would you think it would be diffcult to modify the plugin to "ignore" specials charaters for character value comparison?

For exemple if I search "cliché" I'd like to find "cliche" and "cliché".

Thank you for your time,
Lucien
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, after selection, they replaced with & quot ; in combo box field

Thanks
Baki
0 
Re: Combobox - Item Plugin
by vikram
on April 9, 2013
Hi Madhuri,

Check your plsql process in your plugin settings for adding new record. If you can't make it work then reproduce the problem on apex.oracle.com

Thanks,
Vikram
0 
Combobox - Item Plugin
by Madhuri
on April 9, 2013
hi ,
The update is not happening it is not saving the new added list entry, am I missing something to add

Thanks,
0 
by vikram
on March 22, 2013
Its under shared components > user interface attributes
0 
by Scott
on March 22, 2013
I did find a httpd.conf file in my /etc/httpd/conf/ directory, but there is no /i/ or /I/ in it anywhere???
Exactly what should I be looking for here?

And I did a httpd -V to even find out where this file was (as per the referenced OTN article. Also, in Apex 4.2, there is no way to find it in the Edit Application Properties either.

That and I am still looking for the location of dads.conf where it might also be.
0 
by Scott
on March 22, 2013
I did find a httpd.conf file in my /etc/httpd/conf/ directory, but there is no /i/ or /I/ in it anywhere???
Exactly what should I be looking for here?

And I did a httpd -V to even find out where this file was (as per the referenced OTN article. Also, in Apex 4.2, there is no way to find it in the Edit Application Properties either.

That and I am still looking for the location of dads.conf where it might also be.
0 
RE: Paths
by vikram
on March 20, 2013
Hi Scott,

#IMAGE_PREFIX# will be defined in the dads.conf/httpd.conf

See this
threadhttps://forums.oracle.com/forums/thread.jspa?threadID=899772

For #PLUGIN_PREFIX#
#WORKSPACE_IMAGES# consult documentation http://docs.oracle.com/cd/E23903_01/doc/index.htm

Thanks,
Vikram
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.