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

1 Voters

Add Option to Control Filter Value Behavior in Interactive Report Subscriptions

armen.grigorjan Public · Aug 18 2025

Idea Summary
Currently, when creating a subscription for an Interactive Report in Oracle APEX, the filter values (e.g., date ranges) are stored as fixed values based on the session at the time of subscription creation. This means that even if the page items use dynamic default values (e.g., TRUNC(SYSDATE) - 7), the subscription will always use the static values captured during creation.

This behavior limits the flexibility of subscriptions, especially for reports that are meant to reflect dynamic time periods like "last 7 days" or "current month".

Proposed Enhancement

Introduce a subscription option that allows developers or users to choose whether:

  • Filter values should be stored statically (current behavior),
    or
  • Filter values should be dynamically evaluated at runtime, using the default logic defined in the page or SQL query.

Example Use Case
An Interactive Report has two date picker items:

  • P1_DATE_FROM with default TRUNC(SYSDATE) - 7
  • P1_DATE_TO with default TRUNC(SYSDATE)

When a user creates a subscription, they should be able to choose:

  • Static mode: Save the current values (e.g., 11-AUG-2025 to 18-AUG-2025)
  • Dynamic mode: Use the default logic at runtime (e.g., always "last 7 days")

This would allow subscriptions to remain relevant and accurate over time without manual updates.

Benefits

  • More flexible and powerful reporting
  • Better support for time-based automation
  • Improved user experience and reduced maintenance
We reviewed this idea carefully, and while it was interesting, we concluded that it is unlikely to make its way into APEX in the foreseeable future.

Comments

Comments

  • fac586 OP 2 weeks ago

    Might already be possible—see FR-3589.

  • armen.grigorjan OP 2 weeks ago

    Thanks, but I don't think the problem is as detailed in post FR-3589 as it is described here. The filter suggestions there wouldn't work either. The problem is that when the subscription is created, the values of the current session state are saved and always used. Therefore, the report no longer provides any data at all.

    This can certainly be avoided by setting the default values for P1_DATE_FROM and P1_DATE_TO to a larger time period before creating the subscription. For example, instead of P1_DATE_FROM = TRUNC(SYSDATE) - 7 and P1_DATE_TO=TRUNC(SYSDATE), manually setting the values to P1_DATE_FROM=01/01/2000 and P1_DATE_TO=12/31/2099. Then restricting the desired time period using filters, saving it as a new report, and sibscribing it. However, this isn't a great solution.