Home > FAQs > xCan I create a No Thank You Alert
xCan I create a No Thank You Alert
Need Help on this Topic? Email Support
Yes ~ take these steps to create the alert.
1. Create the email which will be used as the communication piece. This will allow you to make sure you identify all the fields needed in the query.
2. Identify which status is going to be the trigger for the email. Make note of this because you will need to update the statement below by replacing the section in red.
3. Create the alert by going to Maintenance Tools and selecting to Manually Import an Alert.
<Alert>
<AlertCode>NO_THANK_YOU_EMAIL</AlertCode>
<Description>No Thank You Email to Applicant</Description>
<Query>
<![CDATA[select ar.seq, ar.reqcode as code, a.applnum, ar.statusdate, (CASE WHEN a.PrimaryEmail='W' THEN a.WorkEmail ELSE a.Email END) as SendAddress, rtrim(a.lastname)+', '+rtrim(a.firstname) as FullName from appreq ar inner join applicant a on ar.applnum=a.applnum inner join requisition r on ar.reqcode=r.code where ar.Status like 'NTY%' and r.status<>'C' and r.status not like 'CLOSED%' and ar.StatusDate<=getdate()
]]>
</Query>
<RelatedTo>Applicant</RelatedTo>
<Email>Applicant</Email>
<SendOnce>Y</SendOnce>
<LastUpdated>09/09/2019</LastUpdated>
</Alert>
Example with multiple statuses:
<Alert>
<AlertCode>NO_THANK_YOU_EMAIL</AlertCode>
<Description>No Thank You Email to Applicant</Description>
<Query>
<![CDATA[select ar.seq, ar.reqcode as code, a.applnum, ar.statusdate, (CASE WHEN a.PrimaryEmail='W' THEN a.WorkEmail ELSE a.Email END) as SendAddress, rtrim(a.lastname)+', '+rtrim(a.firstname) as FullName from appreq ar inner join applicant a on ar.applnum=a.applnum inner join requisition r on ar.reqcode=r.code where ar.Status in ('WEBAPP','SELFSERV_APP') and r.status<>'C' and r.status not like 'CLOSED%' and ar.StatusDate<=getdate()
]]>
</Query>
<RelatedTo>Applicant</RelatedTo>
<Email>Applicant</Email>
<SendOnce>Y</SendOnce>
<LastUpdated>09/09/2019</LastUpdated>
</Alert>
See also
|