Skip to Main Content
Feature Request FR-1957
Product Area Application Builder
Status CLOSED

33 Voters

Dynamic Column Support For Interactive Grid/Report

shibi.ns Internal · Sep 13 2021

Idea Summary
 We can build dynamic SQL for Interactive Grid/Report regions . but the column selection is design time , we need the ability to run time columns the configuration can be picked up from default . like allow sort , filter etc    

Use Case
What are the use cases in which this idea useful? . create single page to load multiple tables and views 

Preferred Solution (Optional)

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is not feasible in APEX.

Comments

Comments

  • john.snyders APEX Team OP 3.7 years ago

    It is the “Interactive” part, meaning the saved report settings, that makes this tricky. The saved report settings require a stable set of columns. For other report types this makes more sense. See a sample plug-in in IG Cookbook called “Simple Grid” for ideas. 

    I could support this idea for non-interactive reports (new or existing) but not for IR/IG.

  • fac586 OP 3.6 years ago

    create single page to load multiple tables and views

    How would this feature support that use case?

  • shibi.ns OP 3.6 years ago

    Possibly the report should show when the select columns and saved report original columns ?. Ideally this should be advanced option

  • jayson hanes Admin OP 3.6 years ago

    Shibi could you please draft up a more detailed explanation of how this feature could work?

  • shibi.ns OP 3.6 years ago

    Sure . Will do

  • dan.mcghan APEX Team OP 3 years ago

    I've created a new, similar Feature Request here: https://apexapps.oracle.com/pls/apex/apex_pm/fr/r/FR-2594