Stop scheduled reports to send email if no records
Hi Team,
Currently we have scheduled few reports with records in excel attached to the email triggered. But report gets triggered even if there are no records. Please suggest if there is any OOTB way or any customization required to stop email trigger if there are no records.
Thanks
Accenture
SG
Hi @SumitK54, Please check pyExecuteTask (Pega-ScheduledTask-Reporting) if we can customize something in this activity, it's available but Pega has not marked it as extension. Thanks, Vinay
AMEX
IN
@VinayKumarL16594575 tried to use the pxResultCount here but the Report page is not accesible in this activity and all previous activities where report is getting called are Final.
Accenture
SG
Yes, but we have only this place available to write our logic, may be you can run the report here and check for the result count, if the result count is 0 then you can exit the activity.
Thanks,
Vinay