How to get the Count of Records in Excel
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??
Updated: 9 Sep 2022 0:20 EDT
Accenture
SG
Hi @SakethG,
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.
https://support.pega.com/question/stop-scheduled-reports-send-email-if-no-records
Thanks,
Vinay
Cognizant Technology
IN
@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?
Accenture
SG
Completely agree with you on the performance side. But we don't have any other place to check this count. You can submit the feedback to Pega through community moderators.