Is it possible to get dataset values in an email template?

[yogesh2]

Is it possible to fetch dataset values and print them into an email template?

[PremMahadikar]

Hi @yogesh2 ,

Yes, it's possible.

For example: If your analytic query is - select distinct u.username, count(ua.accountkey) as 'Count of Accounts' from users u, user_accounts ua where u.userkey=ua.userkey and u.username='XYZ'

You can print 'Count of accounts' in email with binding variable: ${ANALYTICSDATAMAP.get("Count of Accounts")}

In case you want to print selected or all records from list of result: Refer to below articles: Listing all information in one analytic email with... - Saviynt Forums - 35220

Doc link: Creating and Managing Email Templates (saviyntcloud.com)

If this answers your question, please consider selecting Accept as Solution and hit Kudos

[yogesh2]

This would require creation of an analytics and will only work for emails triggered from Analytics, right?

[PremMahadikar]

@yogesh2 ,

Thats right, the above sample works when email is attached in analytics.

What exactly you want to print in the email body and how you want to trigger this email?

[yogesh2]

I was thinking of storing some environment variables (mainly Saviynt URL) and then get them dynamically without having to update the email templates for each environment.

So the emails I'm referring to could be triggered from any source.

[PremMahadikar]

@yogesh2 ,

This is currently not supported. Similar forum article in past - Re: Global Variable in Saviynt - Saviynt Forums - 12487

Please up-vote this idea - Environment Specific Property File | Saviynt Ideas Portal

If this helps, please consider selecting Accept as Solution and hit Kudos

[rushikeshvartak]

This is supported you can use baseUrlForEmail  https://forums.saviynt.com/t5/ars/base-url-usage-in-email-templates/ta-p/37339

@PremMahadikar FYI

[PremMahadikar]

@rushikeshvartak , Thank for this information.

But the idea posted would help to expose other environment specific variables as well.

@yogesh2 , please try baseUrlForEmail in the email body.

And do up-vote the idea for exposing environment specific binding variables - Environment Specific Property File | Saviynt Ideas Portal 

[rushikeshvartak]

Dataset is not exposed in email template