Unable to send email to $(userEmail}

[Community_User]

Originally posted on November 23 2020 at 10:50 UTC

I am understanding $(userEmail} is someone mentioned username in query but it seems not working with new report I made even if it's working with another report.

SELECT

u.username

,u.firstname

,u.lastname

,u.email AS 'User Email'

,u.username AS 'User Username'

,a.name AS 'Account Name'

,a.accountkey as acctKey

,e.endpointkey

,'disableAccount' AS Default_Action_For_Analytics

,u.employeeid AS 'Employee Number'

,u.customproperty17 AS 'Displayname'

Here is part of SELECT Statement I made. could you please tell me what's wrong.

[Community_User · Accepted solution]

Originally posted on November 23 2020 at 15:28 UTC

Hi

You have to use USERNAME as alias for the u.username and this is case sensitive so only USERNAME will work.