Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/21/2023 01:59 AM
Hello Folks,
I tried to send an email to the user that I got from a Report. Below is a sample how I've done.
Analytics : select u.username as 'username', u.email, u.employeetype, u.startdate, u.enddate from users u where u.username like 'cp006184'
Template :
To: ${ANALYTICSDATA.'email'[0]}
But It won't be triggering the template unless I add ${userEmail} to CC or To
Is there any way that I can use ${Analyticsdata.*} in To instead of using ${userEmail} for this case ?
08/21/2023 06:36 AM
Hi @Joon ,
If you want to send the email to a user from analytics, please proceed as following :
Notes :
Hope this helps !
08/21/2023 06:53 AM
The Email template assigned to the control should contain ${userEmail} in the TO field and ${ANALYTICSDATA.<columnname-with-valid-email>} can be added in CC/BCC field.
For more information about managing email templates, see Creating and Managing Email Templates.
The query should include the username column or any column which contains a valid email id.
Sample Query:
select u.username, u.firstname as 'First Name', u.lastname as 'Last Name',(select
Follow below links for some sample:
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.