Skip to Main Content
Feature Request FR-4681
Product Area Page Components
Status CLOSED

1 Voters

Interactive report conditional saved reports

martin.mirenic2 Public · Oct 6 2025

Idea Summary
Server side condition on interactive report saved reports option

Use Case
Etc. Filtered list of Interactive report saved reports based on some condition, user role, etc.

Preferred Solution
Server side condition option on IR saved report, that also should be check when redirecting to IR saved report using URL. Also option for authorization schema would be great.

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 unlikely to make its way into APEX.

Comments

Comments

  • paulo kunzel APEX Team OP 5 weeks ago

    Hi @martin.mirenic2,

    Please would you mind sharing more information as to the applicability of your idea? In which scenarios would it generate value?

    We were discussing internally and I imagined you have groups of users that don't want to share the reports saved (eg.: SaaS application where very users are groups from different companies)

    But we need to better understand your case.

  • martin.mirenic2 OP 5 weeks ago

    Hi @paulo kunzel, 
    exactly, the idea came from SaaS application where we have tenant specific saved reports. 
    Not just showing or hiding specific columns (which could be done with the server side condition on column itself) but column reordering, highlighting, specific actions on the IR, etc.
    But I see this applicable with different user roles also.
    Etc. administrator can see different set of saved reports from basic user.

  • christina.cho APEX Team OP 4 weeks ago

    Hi @martin.mirenic2 ,

    You can achieve this today by using “Report ID Item” under Advanced attributes for a interactive report region. This attribute allows you to create your own custom Saved Report List instead of using the built-in reports select list. To use:

    • Disable “Reports Select List” from the search bar.
    • Create your own select list item, i.e. P1_REPORT_ID. The LOV for this item can be dynamically queried based on your user role from apex_application_page_ir_rpt view. The LOV should return report_id value from the view.
    • Enter this item name as “Report ID Item” attribute value.
    • Create a Dynamic Action to submit the page to set the session state of this item on item Change event.

    Once you have everything set, users can use this custom item to view saved reports they are allowed to see.

    Hope this helps.