Only want report to load last 30 min of data-CodePudding

I am trying to have an APEX report show only responses submitted in the last 30 minutes. Is it possible to do this with the where clause?

I originally tried using a trigger that feed into a creation date column but I had issues with data showing up into the column and was unable to have the report only show the past 30 minutes.

Any ideas would be helpful,

Thanks!

CodePudding user response：

where clause is the way to do it, e.g.

where date_column >= sysdate - interval '30' minute

because of this:

SQL> select sysdate,
  2         sysdate - interval '30' minute half_an_hour_ago
  3  from dual;

SYSDATE          HALF_AN_HOUR_AGO
---------------- ----------------
04.05.2022 14:37 04.05.2022 14:07

SQL>

CodePudding user response：

I believe you could use a where condition which would be something like:

where submitted_datetime >= (current_timestamp - interval '30' minute)

Do let me know if it works!