Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

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.