Combobox Tweet |
|
|
Categories:
Item Plugin
Overcome Select List & Autocomplete limitationsCombobox (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 |
Company:
Date added: 15.5.2012
Views:
8439
Votes:
31
Reviews:
81
Min. APEX Version:
4.0
Link to:
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. |
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
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
The update is not happening it is not saving the new added list entry, am I missing something to add
Thanks,
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.
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.
#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
Exactly how do I determine the directory paths for
#IMAGE_PREFIX#
#PLUGIN_PREFIX#
#WORKSPACE_IMAGES#
It's not like I can select them from DUAL. Google hasn't helped either.
Firstly - the sample application on hosted instance will work if we change the File Prefix to #WORKSPACE_IMAGES#
Coming to your actual problem - #IMAGE_PREFIX#plugins/combobox_item/ looks fine for me, but you can double check if your APEX image directory is pointing to /opt/oracle/product/11.2.0/dbhome_1/apex/images/
Finally - Debug your page using firebug/chrome to check for the errors in the console for 404 (file not found) errors.
Basically there might be an issue with the file paths, and I assume the custom plugin files are not rendered.
If you cannot sort the issue - share your page source via email to oracleapexideas at gmail dot com
Thanks
Workspace: scottz
ID: vikram
password: password
Run the sample application and look at customer data. The state lookup has been altered to show the built in select list and 3 variations of the combobox and you can see that the comb box does not work. I uploaded the server files into the images, static files, and Cascading Style Sheets areas.
And yes it won't save, but that's not the point. The select list does not work now when I changed the File Prefix from #PLUGIN_PREFIX# to #IMAGE_PREFIX#plugins/combobox_item/
And the documentation on this File Prefix is not very good either.
| Powered by Sigsiu.NET | ![]() |


Combobox
Save This Page
