using trigger for BIP report
Summary:
I am trying to use a trigger for a BIP report and schedule.
Content (please ensure you mask any confidential information):
I only want to deliver the report when there is data, but when I run it it always skips and I'm not sure why. The query should return when any new value has been created in the last 365 days, of which there is in fact data, but when I schedule the report to run with the trigger it always skips. When I run the query by itself in its own DM data is returned, so rownum greater than 0 would evaluate to true.
1