Oracle APEX - IG Single Row Plugin

Sharing a region plugin to render a single row of data in a simple form layout, enabling editing, navigating and refreshing data without page submits. The form can be made part of a Master-Detail setup, with support for single transaction. (click to enlarge)

The plugin is acting as a wrapper around an Interactive Grid. It does so by configuring the IG to use Single Row View only and adjusting the toolbars as to have one toolbar with crud and pagination buttons. The plugin also has some extra (layout) features to the single row view as to enable setting field width, a button to expand/collapse field groups, a feature to enable field columns, and a feature to set the width of the labels. The plugin has workarounds for a number of issues in the APEX underlying recordView widget. For configurations in which the IG Single Row is used in a Master-Detail setting, the plugin offers support to implement Single Transaction.

By making use of IG Single Row Plugin, wrapping the Interactive Grid SRV, it brings the benefit of the underlying AJAX server communication, preventing need for page submits. An example is the use of a Tree, here with a BOM (Bill of Material), where upon a node click, the related BOM Part data is shown in the IG Single Row:

Find a demo page here.