Email Template to define Owner's manager as 'To'

[Community_User]

Originally posted on September 22 2020 at 04:33 UTC

This is SELECT statement from SQL query to check terminated entitlement owner and notify to owner's manager.

SELECT EP.ENDPOINTNAME AS 'Application'

,ET.ENTITLEMENTNAME AS 'Entitlement Type'

,EV.ENTITLEMENT_VALUE AS 'Entitlement Name'

,U.USERNAME AS 'Owner Username'

,U.DISPLAYNAME AS 'Owner DisplayName'

,U.EMAIL AS 'Owner Email'

,CASE

WHEN U.STATUSKEY = 0

THEN 'Inactive'

END AS 'Entitlement Owner Status'

,U1.USERNAME AS 'Manager of Entitlement Owner'

,U1.DISPLAYNAME AS 'Entitlement OwnerOwners Manager Display Name'

,U1.EMAIL AS 'Owners Manager Email'

,CASE

WHEN U1.STATUSKEY = 0

THEN 'Inactive'

ELSE 'Active '

END AS 'Owners Managers Status'

I used

${ANALYTICSDATA.'Owners Manager Email'[0]} to define Owners' manager email.

But email is still not delivered. Please let me know what needs to be modified

Highly appreciated if you can let me know what's the issue.

Thank you

[Community_User]

Originally posted on September 22 2020 at 04:53 UTC

I also tried ${manager.email} but no luck.

[Community_User · Accepted solution]

Originally posted on September 22 2020 at 15:52 UTC

Hello,

${ANALYTICSDATA.'Owners Manager Email'[0]} is the correct syntax in this case.

${manager.email} - this is not supported in Analytics email.

In case, this variable is not working, request you to log a ticket along with the logs.

Regards,

Saparja