The plugin is Oracle APEX item plugin providing new functionalities within text fields.
Basing on APEX list of values the plugin allows to pick values from autofilter and modal popup.
The settings of autofilter, popup dialog and others can be configured with 14 the plugin attributes.
“One dictionary and many select possibilities”
The plugin is compatible with Oracle APEX starting from version 4.1.x. The plugin is compatible with Oracle APEX 5 since version 2.2.1.
The plugin was tested under three major browsers: Internet Explorer 8+, Firefox, Chrome.
The plugin provides autocomplete functionality that allows bussiness users to pick value from the list while typing in textfield. The autocomplete can be configured by APEX developer:
Popup dialog is easy way to choose multiple values from the list or to check currently selected values. In popup dialog, bussiness user can easly filter data and decide what values should be returned.
APEX developer can configure popup dialog:
The plugin integrates with Oracle APEX cascading LOV functionalities. The sequence of columns does not matter - APEX developer decides what column should represent return value and which column should be presented to bussiness user.
The plugin provides 14 substitution strings that can be easly translated with APEX built-in translation tool or within the plugin PL/SQL code.
Check translate-apex.com for more information about localization issues in APEX.
The plugin was tested with large data dictionaries. It can handle up to 30 000 rows dictionaries with quite fast access to it.
The plugin can be applied to the tabular forms using additional dynamic action plugin.
This plugin is currently available for use in all personal or commercial projects under MIT license. License has been included with this software.
The program(s) and/or file(s) are supplied as is. The author disclaims all warranties, expressed or implied, including, without limitation, the warranties of merchantability and of fitness for any purpose. The author takes no responsibility, assumes no liability for damages, direct or consequential, which may result from the use of these program(s) and/or file(s).
The demo of the plugin is interactive which means its configuration can be easly changed (on this page). After submiting new configuration the plugin "APEX Enhanced LOV item" is generated and ready to use.
Attributes below represents attributes of the plugin available in Oracle APEX Application Builder. In section "Predefined examples and dictionary source" are defined presets of configuration.
Configure the plugin with attributes (or pick example configuration) and press button "Generate plugin instance".
The plugin expects two columns which will be used by the plugin to present data data to the bussiness user.
Please click on the button below
After downloading and unpacking the zip archive please proceed with folowing steps:
After installation you are able to create APEX item with the plugin.
Oracle Application Express, PL/SQL and Frontend developer. IT consultant experienced in developing database and web applications using Oracle Application Express.
Oracle APEX enthusiast, plugin developer and active community member.