Skip to Main Content
Feature Request FR-3244
Product Area Shared Components
Status ROADMAP

7 Voters

Allow the use of shared component LOVs in plug-in region columns

philipp.hartenfeller2 Public · Jul 3 2023

Idea Summary
APEX has a great history of extensibility. One feature that native components utilize but that is inaccessible to region plug-ins is access to the LOVs defined in the shared components. The workaround is for users to input the query again in the column, which is a bad pattern. 

Use Case
Region plug-ins that allow the input of data where a select-list-like input is wanted and a LOV is already defined.

Preferred Solution
New Region Column type or add a switch that enables the “List of Values” section the Interactive Grid has to the type “Region SQL Statement Column”.

This section should then appear in the Plug-In column configuration:

A nice API implementation to fetch the records with APEX_EXEC would be nice too.

This is currently on the roadmap for a future release of Oracle APEX.

Comments

Comments

  • vincent morneau Admin OP 1.5 years ago

    Hi @philipp.hartenfeller2 

    I understand this would certainly be useful for plugin developers, however the plugin architecture was designed to be self contained, meaning that there should not be dependencies on local data model, making plugins simpler to share.

  • philipp.hartenfeller2 OP 1.5 years ago

    @vincent morneau 

    Hi Vincent. I phrased my idea a little bit poorly. I don't want to access LOVs inside the plug-in builder. Instead, I want to allow users to reference LOVs in the page designer when using the plug-in.

    This is possible for item plug-ins, like in Select2, where you could just reference a LOV. However, this is missing in region plug-ins for the columns. 

    My wish for it arose from creating an Interactive Grid like plug-in. In IG, you can set a column type to select list or popup LOV and reference a LOV. For my plug-in, I can't allow users to reference LOVs as there is no such type in the region column attribute settings.

  • vincent morneau Admin OP 1.5 years ago

    @philipp.hartenfeller2 Ah, I see. Re-opening. We will reconsider.