Combobox With Custom Display Tweet
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.
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:
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.
Thanks for great plugin. Is it possible to make it works in APEX 5.0 ?
VALUE = 'SMI' would return
but would not return
so it is a VALUE% not %VALUE% ?? Thxs
2. if display data contains double quote, they replaced with & quot ; and after selection remains in combo box field
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
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.
my combo box item P9_DEPT
select DMS_DT_ID from DMS_DEPT_TYPE
Yes you have to use following syntax given in the plugin documentation above.
I've also added dynamic action: Set Value.
But still ...
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.
Thank you very much,
|Powered by Sigsiu.NET|