Dynamic value in email template TO

[Ekata]

Hi Team,

We have a requirement to have an analytic in place to trigger email to the helpdesk as per their location if the first name or last name is null or invalid.

For example, if user first name is NULL and user's location is Paris the email should go to parisTSGhelpdesk@abc.com

Can we achieve this without using dataset. Please advise.

Regards

[dgandhi]

Please check below solution:

1. Create one analytics with below sample query

select u.username,u.email
from users u
where (u.firstname is null or u.firstname = '')
and u.location='Paris'

2. Create one email template and in email template to section , add the dl that you mentioned 'parisTSGhelpdesk@abc.com'

3. In your analytics config, attach above created email template.

4. Now when you run the analytics , the output of the analytics will be sent to above mentioned dl

Thanks

[Ekata]

Hi Devang,

Thanks for the response but this is a direct approach for 1 location, I have 85 locations for which it should check and send the email template. How we can use it that time.

Location value will be there in users table.

[dgandhi]

Modify the query like below u.location in ('Paris','XYZ','ABC')

Thanks

[Ekata]

Hi,

Thanks but I wanted to know about the TO section. 

[sk]

You can use if else conditions but problem I foresee is, if the logic length goes beyond 1024 chars then it will fail because TO column is varchar(1024)

[rushikeshvartak]

You can store values in endpoints cp and use in TO