New Joiner
- Helen Ustych
- Daria Chebotaieva
Summary | The notification mail is sent to specific email addresses when a new crew profile is created in Adonis. |
|---|---|
Keywords | New Employee |
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
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's email and name.
Set the option “Dynamic from database“.
Set #Email in the 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
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