Start
Features at a Glance
Roadmap
Requirements
Versions
License
Live demo
Download
Author

Data to collection has been loaded

Enhanced LOV item

Oracle APEX dynamic action plugin for Tabular Form v1.0

The plugin is dynamic action plugin dedicated to use with custom tabular forms based on classic reports. The plugin implements functionalities of "Pretius APEX Enhanced LOV item" (PAELI) plugin within tabular form by redirecting JS events from tabular form text fields to created instances of PAELI plugin. Thanks to the plugin, bussiness user can use autocomplete and modal dialog selection in tabular forms.

Features at a Glance

Compatibility with Oracle APEX

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.

APEX Enhanced LOV item in tabular form

The plugin extends text fields in tabular form with capabilities of the plugin Enhanced LOV item (read about the plugin here). After applying the plugin to the report text fields columns it is possible to use almost every functionality of the plugin Enhanced LOV item. Check the demo section to test the plugin in action.

Browser support

The plugin was tested under three major browsers: Internet Explorer 8+, Firefox, Chrome.

Roadmap

Support for paste event;

Requirements

The plugin requires installed plugin "Pretius APEX Enhanced LOV item v.2.2.1" to work.

Versions

This is the first version of the plugin. No version history is available.

License

This plugin is currently available for use in all personal or commercial projects under MIT license. License has been included with this software.

Legal Disclaimer

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).

Live demo

Demo below presents plugin in action binded with APEX Classic Report and Interactive Report. Reports source are defined as APEX collections and it can be modified by clicking "Save" button.

The plugin is binded to after refresh DA event and each time pagination or number of rows is changed the plugin alternate report columns with fake PAELI plugins.

New

Rows

Job title

Colors

Id	First name	Last name	Gender
578	Jeffrey	Chavez	Male
625	Chris	Turner	Male
986	Daniel	Lopez	Male
4	Samuel	Bryant	Male
5	Jeremy	Miller	Male

row(s) 1 - 5 of 128

APEX item: P50_TF_JOB_TITLES
Autocomplete available: Yes
POPUP DIALOG available: Yes
POPUP DIALOG Multiple selection: No
Autocomplete search cases: %search_string%
Values separator: :
Debounce time in ms: 300
Enable paste event: No
Autocomplete filter by column: Column_2
Column sequence: Column_1, Column_2 | Column 2 asc
Max length for multiple values: 100
Show return column: No
Submit when enter pressed: No
Show APEX processing: N
Recreate collection on page load: No

APEX item: P50_TF_COLORS
Autocomplete available: Yes
POPUP DIALOG available: Yes
POPUP DIALOG Multiple selection: Yes
Autocomplete search cases: %search_string%
Values separator: :
Debounce time in ms: 300
Enable paste event: No
Autocomplete filter by column: Column_1
Column sequence: Column_2, Column_1 | Column_2 desc (number)
Max length for multiple values: 150
Show return column: No
Submit when enter pressed: No
Show APEX processing: N
Recreate collection on page load: No

Plugin instances: P50_TF_JOB_TITLES,P50_TF_COLORS
Column names: f11,f12

Download

Please click on the button below

Installation guide

After downloading and unpacking the zip archive please proceed with folowing steps:

Select application you want to install plugin
Go to Shared Components > Plugin-ins
Click import button
Choose installation file and proceed with installation steps.

Usage guide

On APEX page X create:

Report region with textfield column using apex_item package (named f01)
New APEX item using plugin "Pretius APEX Enhanced LOV item" named PX_EXAMPLE_1
- Set desired configuration of the plugin
- Set "Region" = "<Report created in step #1>"
New dynamic action:
- Event = "After Refresh"
- Selection Type = "<Report created in step #1>"
Dynamic action "True action":
- Action = "PAELI in tabular form"
- Set plugin attribute "Plugin instances" = "PX_EXAMPLE_1"
- Set plugin attribute "Column names" = "f01"
- Fire On Page Load = "Yes"

Run the page and test the plugin in action.

To bind more then one column you need multiple instances of the plugin "Enhanced LOV item (item pluign)". Multiple item names and column names should be provided to the plugin attributes using comma as separator.

About the author

Bartosz Ostrowski

@bostrowsk1
bostrowski@pretius.com

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.