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

How to find total rows/records in Analytics Report

Harish_Yara
New Contributor III
New Contributor III

Hi Team,

Is there any way to get the total count of records/rows in analytics report. I would need total count of analytics data and based on count email has to be configured in To address of email template

Please help us here. @rushikeshvartak @avinashchhetri

Thanks,

Harish

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

<%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.

Harish_Yara
New Contributor III
New Contributor III

@rushikeshvartak- It is working fine. Thanks. Here my use case if total records are > 250 then ${ownerEmail} else "".

Can you please help me with the syntax?

Thanks,

Harish

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

https://compiler.javatpoint.com/opr/test.jsp?filename=IntegerEqualsExample3

if(objA.compareTo(objC)>0)System.out.println("greater");


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

Harish_Yara
New Contributor III
New Contributor III

Hi @rushikeshvartak

Below one I tried it was working fine for me.

<%if(java.lang.Integer.parseInt(totalRecords.toString())>250) print "${ownerEmail}" else print "NULL" %>

Thanks,

Harish