| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||||
|---|---|---|---|---|
Description | New Joiner | Summary | Notification mail ||
|
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.
...
Keywords
...
New Employee
...
File / Script Link
...
Compatibility APM Version
...
N/A
...
Compatibility SQL Version
...
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 email and name.
Set the option “Dynamic from database“.
...
4. Insert Email Body. Note that you can insert screenshots, links, and signatures to the mail body.
...
SQL
...
Statement
| Code Block |
|---|
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 |