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.
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)
combobox,autocomplete,apex,plugin,combobox add new
Do you have a question about this Plugin? Want to write a Review or Comment?
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
I tried the demo version but the
Lazy Loading & Add New
looks like not working: I type aaxx in the field.
the message says 'add aaxx to list' , but then nothing happens.
i have set Lazy Loading to Yes and Allow New to Yes and written a plsql code containing one insert statement that is suppose to insert the value into the database but its not doing so. Is there sth that I am missing out? Is there any demo to see how to implment this plugin at the background on apex?
May be have you another solution.
I will have a look into the issue and fix it soon.
You can achieve that by customizing the plugin code, so its a customization and I don't see it as a standard functionality.
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,
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
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
The update is not happening it is not saving the new added list entry, am I missing something to add
|Powered by Sigsiu.NET|