Skip to Main Content
Feature Request FR-3609
Product Area APIs
Status CLOSED

4 Voters

Make Interactive Report JS API available

mustufa.kasidwala Public · Feb 7 2024

Idea Summary
Provide javascript APIs to customize interactive report features. Right now, there is no documented way to use javascript APIs to work with interactive reports, most of the examples are either hacks or workarounds. We should have a stable and document API list so it is easier to customize interactive reports.

Use Case
Various use cases in an application I am working with, that can't be achieved right now or have to rely on undocumented APIs

1. JS API needed to add Buttons to do actions from the IR's Action menu.

2. JS API to apply a filter automatically when IR report is loaded

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.

3 Comments

Comments

  • john.snyders APEX Team OP 1.3 years ago

    I agree. This has been asked for ever since IR became a widget, although not asked in a while.

    Interesting use cases. Note that even IG doesn't have a supported API for (2).

  • john.snyders APEX Team OP 1.3 years ago

    This is closed because it can't be actioned as described all at once. As we work on Interactive Report some things will need APIs and we can consider other things at the same time. It is likely that the APIs will be added as part of the region interface and not as a widget style API (so more like facetsRegion and not like interactiveGrid widget). 

    Just in case you are not aware there is a PL/SQL API for setting IR filters. See APEX_IR in the API reference.

  • mustufa.kasidwala OP 1.3 years ago

    Thanks for the comments @john.snyders, the requirement to add filters automatically or programmatically is becoming critical for us. We can use APEX_IR but the problem is it will add the filter even if one exists already. This is the reason I was hoping to get the full javascript API information of IRs. It looks like Interactive Grid has this feature but not IR. Any other ideas you might have that can help us?