Send email notification to managers when reportee's end date is expiring.

[yogarajk]

Hi Team,

We have a requirement to send email notification to managers when the users end date is expiring. We are using the below mentioned query in analytics and binding variables in email template.

Query:

"select u.username as 'username', (select m.email from users m where u.manager = m.userkey) as 'Manager Email', u.email, u.employeetype, u.startdate, u.enddate from users u where curdate() = DATE_ADD(u.enddate, INTERVAL -7 DAY)"

Binding variables in Email Template:

TO - ${ANALYTICSDATA.'Manager Email'[0]}

CC - ${userEmail}

Our requirement is to send email notification to managers only not to the users, but the email is not triggering without ${userEmail} in TO or CC.

Please suggest the possible solution to achieve this requirement.

Thanks in advance!!

Regards,

Yogaraj K

[rushikeshvartak]

• select u.username as 'user username', (select m.username from users m where u.manager = m.userkey) as 'username', u.email, u.employeetype, u.startdate, u.enddate from users u where curdate() = DATE_ADD(u.enddate, INTERVAL -7 DAY)"

[yogarajk]

@rushikeshvartak  Is there any possibilities to hide the username column in the email report