Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/26/2024 02:01 PM
Email notification is not working, it used to work not sure what causing the issue, below is the email body and using binding variable ${userEmail} to send email to manager,
A new vendor has been created
<table>
<tr>
<th>VendorUsername</th>
<th>First Name</th>
<th>Last Name</th>
<th>Company</th>
<th>Employeetype</th>
<th>Manager Name</th>
<th>Date Created</th>
<th>CREATEDBY</th> </tr>
<% int count=Integer.parseInt("${ANALYTICSDATA.size()}"); for(int i=0;i<count;i=i+1){%> <tr>
<td>${ANALYTICSDATA.'VendorUsername'[i]}</td>
<td>${ANALYTICSDATA.'First Name'[i]}</td>
<td>${ANALYTICSDATA.'Last Name'[i]}</td>
<td>${ANALYTICSDATA.'company'[i]}</td>
<td>${ANALYTICSDATA.'employeetype'[i]}</td>
<td>${ANALYTICSDATA.'Manager Name'[i]}</td>
<td>${ANALYTICSDATA.'Date Created'[i]}</td>
<td>${ANALYTICSDATA.'CREATEDBY'[i]}</td> </tr> <% } %> </table>
Analytics Query
select
u.username AS 'VendorUsername',
u.FIRSTNAME as 'First Name',
u.LASTNAME AS 'Last Name',
u.Companyname as company,
u.employeetype as employeetype,
u.CREATEDATE as 'date created',
m.displayname as 'Manager Name',
m.email as 'Manager Email',
m.username AS 'USERNAME',
u.OWNER as Owner,
u.createdby as 'CREATEDBY'
from users u,
users m
where u.CREATEDATE > NOW() - INTERVAL 24 HOUR
and u.manager = m.userkey
and u.statuskey = 1
and u.employeetype in ('Vendor','Contractor')
and u.orgunitid in ('ABC')
Logs
09/26/2024 02:04 PM
This is known product defect in 24.5 please raise support ticket
09/26/2024 02:06 PM
@rushikeshvartak Thank you will submit a support ticket. But it was working couple months ago.
09/26/2024 05:21 PM
Its known issue in 24.5 version refer thread