Functionality : We getting the records from DB using Report Definition and Converting them into Excel sheet and sending them to Users using Scheduled Report. But even when there are no records in the Excel, Still Scheduled Report is sending report to users as there is no filter condition in Scheduled Reports.
Requirement : When there are no records in Excel, We should not send that report to Users.
Description : Most of the activities we are using are OOTB and Final except the first and last. So there is no scope to make any changes to add when condition and restrict. We are having .pxResultCount property (on Page pyTempContentPage) with the Count of Records but it is not retained to be used till the end in Activity "pyActionSendMail".
Rules Used : pzRunScheduledShortcut, pzRDExportWrapper, pxRetrieveReportData, pyActionSendMail etc.
is there any way to get the .pxResultCount from Report Definition without modifying any OOTB activities??
Iam not sure how to fulfill this functionality. Can someone please help me out??
***Edited by Moderator Marissa to add Capability tags***
We have similar discussion going on in the below thread. We have only one place (pyExecuteTask (Pega-ScheduledTask-Reporting) where we can run the report and get the count and exit activity but still this is not a extension rule.
@VinayKumarL16594575 I have gone through that link already but Calling RD again will cause performance issues right? so we are looking for some better solution for this. Pega doesn't provide any solution for this?
Posted: 4 months ago
Posted: 9 Sep 2022 4:54 EDT
L Vinay Kumar (VinayKumarL16594575)