Cyber Recruiter powered by Visibility Software
Help & Support Center

 

 

Search:

 

 

Contents
:
IndexBookmarkPrint

Home > FAQs > Can I create a No Thank You Alert

Can 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