Description

The notification mail is sent to specific email addresses when a new crew profile is created in Adonis.

• The select statement checks all the crew profiles created in the last 24 hours.

• The mail is not sent if the Employment start Date or Rank is empty.

Setup

1. Go to Setup > Notification Service.

2. Add New, give the task a name, and define time and date settings. On the Task Schedule tab, for Date setting > Repeat on Dates set the option “Daily“. Option “Repeat during the day“ should be off. For more details on the settings, please check Notification Service#ScheduleTask

3. Under the Notification E-mails tab, define the Sender email and name.

Set the option “Dynamic from database“.

Set #Email in Field identifying email address and enter E-mail subject:

4. Insert Email Body. Note that you can insert screenshots, links, and signatures to the mail body.

SQL Statement

select
distinct
p01.pin #pin,
FORMAT (p01.EMPLOYMENTSTARTDATE, 'dd/MM/yyyy') #Employmentstartdate,
p01.firstname #Firstname,
p01.lastname #Surname,
org.name #Organization,
c02.name #Rank,
'email1, email2, email3' #email,
'helen.ustych@adonishr.com' as #TestEmail
from
pw001p01 p01
join pworg org on org.numorgid=p01.client
join pw001c02 c02 on c02.code=p01.RANK
where (select (CREATETIME) from PW001P01 where PIN = p01.PIN)>dateadd(HOUR,-24,GETUTCDATE())

and EMPLOYMENTSTARTDATE is not null