Home

Text Field Autocomplete - LOV Friendly

Intended to be a fully functional replacement for "Text Field with autocomplete" item type extended to work with standard LOV. Just as useful both as a page item type as well as an introduction to plugin development by example.

Installation

1. Ensure you are running Oracle APEX version 4.0 or higher
2. Unzip and extract all files
3. Access your target Workspace
4. Select the Application Builder
5. Select the Application where you wish to import the plug-in (plug-ins belong to an application, not a workspace)
6. Access Shared Components > Plug-Ins
7. Click [Import >]
8. Browse and locate the installer file, lov-friendly-autocomplete.sql
9. Complete the wizard

Known Issues

Known issue #1: Unfortunately this plugin actually conflicts with the standard "Text Field with autocomplete" item type. You can not use both on the same page. Attempting to do so should disable both and display an alert box warning the developer.

Known issue #2: It seems there is a bug in APEX_PLUGIN_UTIL that effectively prevents LOV's containing long concatenated columns unless using a column alias. Any more than 30 character identifier and the results wont get returned.

See README.txt for further details.