Skip to Main Content
Feature Request FR-3386
Product Area Shared Components
Status CLOSED

2 Voters

Bind Variables in Shared Dynamic LOV's

phil.grinham Public
· Sep 21 2023

Idea Summary
I have numerous cases where a dynamic LOV on one page is almost identical to another on a different page, the only difference being that it uses :PXX_ITEM from one page but a different page item on the other; otherwise the SQL is identical.

Use Case
To reduce code duplication and centralise the LOV definition in the shared components.

Preferred Solution (Optional)
Allow for the dynamic LOV in the shared components to have bind variable placeholders in the SQL and either APEX can detect these and list them in the page using it. Provide a new input field for items that allow a shared LOV to be its source where the bind variables in the SQL will be replaced by a comma or colon separated list of page items.

This request is likely a duplicate of FR-1988.

Comments

Comments

  • fac586 OP 1.8 years ago

    Duplicate of FR-1988 (and 2755/2797/3194/3338…)