How to fetch user's manager email in email template which is getting triggered through analytics

[Ajit]

Hi Team,

We have configured a notification that is triggered through analytics to each user separately, we want to add the user's manager email id in the TO/CC field. Could you please tell us which parameter we can use for this?

Thanks

[CR]

@Ajit  try below like attribute with your mail id

cc : ${manager.email},abc@gmail.com

[Ajit]

@CR  Thank you for the response, tried but not working. The email is not getting triggered.

[CR]

@Ajittry

${owner.email},

[Ajit]

@CR not working. The email template is tagged in an analytics. We tried some parameter from the documentation but not working.

[CR]

@Ajit i tried , am getting mails also above thing.

try like below prepare  query , based below sql we are getting manager mail example

select u.username as 'UserUsername',u.displayname as 'Displaynameee',u.EMPLOYEETYPE,u.companyname,DATE_FORMAT(u.startdate,'%Y-%m-%d') AS 'Startdte',DATE_FORMAT(u.enddate,'%Y-%m-%d') AS 'enddte',u.departmentname,u.country,um.username as Username,um.email as 'ManagerEmail' from users u , users um where u.manager=um.userkey and u.statuskey=1 and DATE_FORMAT(u.enddate,'%Y-%m-%d') = DATE_ADD(CURRENT_DATE(),INTERVAL +3 DAY)

and cc you include based ManagerEmail email column

like ${ANALYTICSDATA.'ManagerEmail'[0]}

[Ajit]

@CR  ${owner.email} is this working for you?? if yes - are you also fetching the user's manager email in the analytics query?

[CR]

without query its working.

[Ajit]

@CR  Is there anything I am missing? please suggest

[CR]

@Ajit 

${owner.email},ajith@gmail.com

like below

[rushikeshvartak]

To get what variables are present to use in the email template, check using the below expression. By putting it in the email body, it will print all variable names with values, and then accordingly, you can use it:


${this.binding.variables.each {k,v -> println "$k = $v" + "" + "br" + ">"}}

[Ajit]

@CR @rushikeshvartak  We tried with - ${ANALYTICSDATA.'ManagerEmail'[0]}, its triggering the emails to user's manager.

But, if multiple users are coming as the outcome of the analytics query, then email to all users are triggering only when we are writing the parameter like below in the to/cc field of the email template:

${ANALYTICSDATA.'ManagerEmail'[0]}, xyz@abc.com

It's triggering to only one user if we are using as below: 

${ANALYTICSDATA.'ManagerEmail'[0]}

Could you please suggest what could be the reason here?

[CR]

@Ajit  - your question it should trigger all manager right, am correct?

[Ajit]

@CR yes for example if 3 users are coming in analytics, it should trigger to all 3 users ccing their manager.

It's working this way but only when we are adding a static email along with ${ANALYTICSDATA.'ManagerEmail'[0]}.

[CR]

try  below and confirm

[Ajit]

@CR  We tested in the same way as you have mentioned above, but instead of 3 emails(to all users who are part of analytic outcome) only one email is getting triggered.

It's triggering to all users, only if we are using like below:

[CR · Accepted solution]

mail will get manager inbox , can you check user manager mails please
To : ${userEmail}
Cc : ${ANALYTICSDATA.'ManagerEmail'[0]}