Hello,
It is working now, I used this Analytics :
SELECT distinct
u.USERNAME AS 'Employee_username',
u.firstname AS 'User_Firstname',
u.lastname AS 'User_Lastname',
m.username AS 'USERNAME',
m.firstname AS 'ManagerFirstName',
m.lastname AS 'ManagerLastName',
u.manager AS 'ManagerUserkey',
m.email AS 'ManagerEmail'
FROM users u INNER JOINusers m ON m.userkey = u.manager
WHERE u.statuskey = 1 AND ( (Date_format(u.enddate, '%Y-%m-%d') - INTERVAL 546 DAY) = Date_format(Curdate(), '%Y-%m-%d') )
and this is the Email Template :
To : ${userEmail}
<body><p style="text-align:left"><span class="title1">Account Creation /</span><span class="title2">Création d'un compte</span></p><br><p>Bonjour ${ANALYTICSDATA.ManagerFirstName[0]} ${ANALYTICSDATA.ManagerLastName[0]},</p><p>Voici la liste des utilisateurs vous appartenant dont la date de fin de contrat est dans 30 jours :</p><table border="1"><thead><tr><th>Prénom</th><th>Nom de famille</th></tr></thead><tbody> <%
int count = Integer.parseInt("${ANALYTICSDATA.MANAGER.size()}");
for (int i = 0; i < count; i = i + 1) {
%> <tr><td>${ANALYTICSDATA.User_Firstname[i]}</td><td>${ANALYTICSDATA.User_Lastname[i]}</td></tr> <%
}
%> </tbody></table></body>
Thanks All
