Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Can we send Analytics report only when there is data(results) ?

IAM_99
Regular Contributor II
Regular Contributor II

Hi Team,

We have analytics report scheduled , How to send email - only when there is result set/data returned by sql query.

1 REPLY 1

rushikeshvartak
All-Star
All-Star

Use below condition in TO email template

<%if (totalRecords.equals(0)) print "NULL" else print "${ownerEmail}" %>


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.