How to send the email through analytics when we have 0 records.

[Prashant]

Hi,
Can you please help me with below query ?
"How to send the email through analytics when we have 0 records."

Thanks

Prashant

[dgandhi]

Do you means reports are not getting delivered when the analytics query fetches 0 record?

[SumathiSomala]

@Prashant Even if the record count is 0 , email will be triggered to intended members after analytics job ran.

Are you facing any issue?

[Prashant]

 Yes @SumathiSomala  and @dgandhi ,

When the analytics results 0 value Email template is not triggering .

[SumathiSomala]

@Prashant  refer below forum threads

Analytics Email - Query return 0 Record - Saviynt Forums - 56805

No Email Notification On Empty Analytic Report | Saviynt Ideas Portal

[Prashant]

Hi @SumathiSomala ,

Thanks for sharing it ,IAS per the refrnces in EIC version it won't trigger the email template when the query return 0 value.
please suggest any alternative method ,if possible 

[dgandhi]

This is expected behavior.

https://ideas.saviynt.com/ideas/EIC-I-5108

[rushikeshvartak]

This is expected behaviour  that it won't send email but if still need email then you can create another analytics where it will show analytics with zero records.

SELECT analyticsname,
       Substring_index(Substring_index(metadata, '"totalData":', -1), ',', 1) AS
       totalData
FROM   analyticsconfiges
WHERE  Substring_index(Substring_index(metadata, '"totalData":', -1), ',', 1) =
       0 

https://ideas.saviynt.com/ideas/EIC-I-5108