...
Description
...
New Joiner
...
Summary
...
| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||||
|---|---|---|---|---|
|
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.
...
Keywords
...
New Employee
...
File / Script Link
...
Compatibility APM Version
...
N/A
...
Compatibility SQL Version
...
N/A
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
| 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 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 |