APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update/Refresh Interactive Report with buttons

lirecsicnarfMar 23 2020 — edited Mar 24 2020

Hi,

I have APEX 18.1 and I'm currently building a Dashboard for our sales. I have 3 buttons (Today, This Week, and This Month) and an Interactive Report which I want to update the values base on what button is clicked.

The IR has this query:

select id, name, sum(qty) qty, sum(amount) amount
from tb_sales
where eodate = (this i want to depend on the button)

Eg: Button 1 = trunc(sysdate)

Button 2 = trunc(sysdate - 7) and trunc(sysdate)

Can someome give an example or help me achieve this.

Thanks.

Added on Mar 23 2020

#apex-discussions

6 comments

3,142 views