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

Slour

Summary

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

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

Slour

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

Venkat Thota - BIP

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

Venkat Thota - BIP

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