Stop BI publisher report if no row is returned in data model SQL query

Question

Summary

Content

Hi All,

I am new to BI Publisher reporting and want to avoid blank report if no rows selected in the query.  Please let me know how I can stop.

E.g   I am using f/w query:

select target_type,count(*) CNT from mgmt$target where broken_str is not null;

In this, if there is no such target with broken state, a blank report is sent to the confirmed email. I want to avoid this.

Thanks,

Shyam

Venkat Thota - BIP · Answer

please mark it as correct so that we can close thread.

Slour · Answer

Yes Venkat, I am using EMAIL server and used triggers just now. It worked as expected. Thanks !!

Venkat Thota - BIP · Answer

are you scheduling the report to email server , if yes then you can schedule trigger https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-30C07845-5BCD-4D02-A829-BA6D85B8599D.htm#BIPDM389