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

2 Voters

Subscribing APEX report Daily/weekly, not populating based on the current date. The report subscription work with initial value.

fnm_muzaffar2000 Public · Jan 23 2024

Idea Summary
The subscribing report should be able to populate data based on the current date.

Use Case
We have some daily/weekly report to be automated for the users on daily/ weekly basis. We have used oracle Apex subscription for the same. Initially we subscribed the report on 11th Dec, 2023. And the report looks fine with 11th Data. But following week 18th also we got the same report with 11th Data. But here we want data as of date it is running in the subscription . 

Preferred Solution (Optional)
Subscription can have some parameter to run the report by passing value for page item/ prompt value.

This is a great idea! You can already achieve this in APEX today with a slightly different approach.

Comments

Comments

  • andrea.hanes APEX Team OP 1.3 years ago

    I would be nice to select sysdate.  In the meantime, have you tried applying a filter with your date column chosen, operator as ‘is in the last’ and expression of a number of hours that make sense?  (Like if your report runs at 3PM, you might enter 7 hours).  I've set up weekly reports and have used the column→is in the last→7 days.

  • menno.hoogendijk APEX Team OP 1.3 years ago

    You can use sysdate by adding a Row Filter to the Interactive Report. If you open the action menu and choose filter, navigate to the Row Filter tab and add you custom expression. E.g.
     

    <COL_ID> >= SYSDATE - 7