question Re: I need to send notification on employee work anniversary. in Virtual Agent forum

I need to send notification on employee work anniversary.

niveditakumari — Sun, 15 Dec 2024 18:08:24 GMT

Hi,

I need to send notification on employee work anniversary.

To achieve that I have created :

1. Event

2. Schedule Job

var gr = new GlideRecord('sys_user');

gr.addQuery('active=true^u_hr_hire_dateISNOTEMPTY^nameLIKEnivedita');

gr.query();

while(gr.next()) {

var hireDate = gr.u_hr_hire_date; //this field is date of joining

var hireMonth = hireDate.substring(5,7); //getting month from date of joining

var hireDay = hireDate.substring(8,10); //getting day from date of joining

var todayDate = new GlideDateTime(); //getting today date

var todayMonth = todayDate.getMonth(); // getting today month

var dayOfMonth = todayDate.getDayOfMonthLocalTime(); // getting today day

gs.log('hire date is' + hireDate);

gs.log('hire month is' + hireMonth);

gs.log('hire day is' + hireDay);

gs.log('today date is' + todayDate);

gs.log('today month is' + todayMonth);

gs.log('today day is' + dayOfMonth);

if(hireMonth == todayMonth && hireDay == dayOfMonth) {

c++;

gs.eventQueue('sn_hr_core.work.anniversary.notification', gr, '', gr.name);

gs.log('notification sent');

}

gs.log('count is' + c);

}

When I'm writing code for nivedita for particular user then it is checking if condition and it is executing code that is written after if condition but when I'm writing code for all user it is not checking if condition.

var c= 0;

var gr = new GlideRecord('sys_user');

gr.addQuery('active=true^u_hr_hire_dateISNOTEMPTY'); /////////////////////////////////////////////

gr.query();

while(gr.next()) {

var hireDate = gr.u_hr_hire_date;

var hireMonth = hireDate.substring(5,7);

var hireDay = hireDate.substring(8,10);

var todayDate = new GlideDateTime();

var todayMonth = todayDate.getMonth();

var dayOfMonth = todayDate.getDayOfMonthLocalTime();

gs.print('hire date is' + hireDate);

gs.print('hire month is' + hireMonth);

gs.print('hire day is' + hireDay);

gs.print('today date is' + todayDate);

gs.print('today month is' + todayMonth);

gs.print('today day is' + dayOfMonth);

if(hireMonth == todayMonth && hireDay == dayOfMonth) {

c++;

gs.eventQueue('sn_hr_core.work.anniversary.notification', gr, '', gr.name);

gs.print('notification sent');

}

gs.print('count is' + c);

}

Can you please help me to correct that code.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

SAI VENKATESH — Sun, 15 Dec 2024 21:02:47 GMT

Hi @niveditakumari

You can probably try using Flow Designer; it will be much more easier.

then use Lookup Records and filter based upon the conditions you needed.

and then use the Action "send Email

If you have any questions, please feel free to ask.

Thanks and Regards

Sai Venkatesh

Re: I need to send notification on employee work anniversary.

Sai_Charan_K — Mon, 16 Dec 2024 05:18:06 GMT

Hi @niveditakumari ,

If you still wish to go with the scheduled job itself, please find the below script:

Scheduled Job:

var gr = new GlideRecord("sys_user"); //gr.addActiveQuery(); gr.addQuery("active=true^u_date_of_joiningISNOTEMPTY"); gr.query(); while (gr.next()) { var jdate = gr.u_date_of_joining.toString(); var to_date = new GlideDateTime();//current day's date var jday = jdate.split("-")[2]; //joining date var jmonth=jdate.split("-")[1]; //joining month if(to_date.getMonth().toString()==jmonth &&to_date.getDayOfMonth().toString()==jday){ gs.eventQueue("joining.notification",gr,gr.name.toString(),gr.email.toString()); } }

Attached are the screenshots of the event logs that got triggered depending upon the joining dates of the user stored in user table.

This code is tested and works fine for me, So please do give it a try.

Please mark this solution as "Helpful" and "Accepted Solution" if this solution helped you in any way.

Thanks and Regards,
K. Sai Charan
Sr. ServiceNow Developer
Deloitte India

Re: I need to send notification on employee work anniversary.

Ankur Bawiskar — Mon, 16 Dec 2024 05:28:19 GMT

@niveditakumari

you don't need to do this much string manipulation to get the month and day

simply use filter condition like this

var c = 0; var gr = new GlideRecord('sys_user'); gr.addEncodedQuery('active=true^u_hr_hire_dateONToday@javascript&colon;gs.beginningOfToday()@javascript&colon;gs.endOfToday()'); gr.query(); while (gr.next()) { c++; gs.eventQueue('sn_hr_core.work.anniversary.notification', gr, '', gr.name); } gs.print('count is' + c);

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 06:42:04 GMT

Hi @Ankur Bawiskar,

Can you please make me understand that line

gr.addEncodedQuery('active=true^u_hr_hire_dateONToday@javascript&colon;gs.beginningOfToday()@javascript&colon;gs.endOfToday()');

What this complete script is doing.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

Ankur Bawiskar — Mon, 16 Dec 2024 06:48:59 GMT

@niveditakumari

change will be required in above script

update as this

var gr = new GlideRecord('sys_user'); gr.addActiveQuery(); gr.addQuery('u_hr_hire_date', 'ISNOTEMPTY'); while (gr.next()) { var hireDate = new GlideDateTime(gr.u_hr_hire_date); var today = new GlideDateTime(); if (hireDate.getMonth() == today.getMonth() && hireDate.getDayOfMonth() == today.getDayOfMonth()) { gs.eventQueue('sn_hr_core.work.anniversary.notification', gr, '', gr.name); } }

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 07:10:22 GMT

Hi @Sai_Charan_K,

I have used yourt code but it is not working.

Please find attached screenshot :

Notification(When to send)

Who will receive

Background Script print

Background Script

var gr = new GlideRecord("sys_user");

//gr.addActiveQuery();

gr.addQuery("active=true^u_hr_hire_dateISNOTEMPTY");

gr.query();

gs.print('hire date is');

while (gr.next()) {

var jdate = gr.u_hr_hire_date.toString();

var to_date = new GlideDateTime();//current day's date

var jday = jdate.split("-")[2]; //joining date

var jmonth=jdate.split("-")[1]; //joining month

if((to_date.getMonth().toString()==jmonth) && (to_date.getDayOfMonth().toString()==jday)){

gs.eventQueue("sn_hr_core.work.anniversary.notification",gr,gr.name.toString(),gr.email.toString());

gs.print('notification sent to employee');

}

Code is not working. It is not checking if condition.

Can you please correct that.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

Sai_Charan_K — Mon, 16 Dec 2024 07:13:34 GMT

Can you try printing jday and jmonth values in background script ?

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 07:15:24 GMT

Hi @Ankur Bawiskar,

I have written code but it is not working. It is not checking if condition. It is printing hire date is but not printing notification is sent to employee.

Can you please help me to correct code.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 07:24:58 GMT

Hi @Sai_Charan_K,

I have printed Jday, Jmonth.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

Ankur Bawiskar — Mon, 16 Dec 2024 07:27:20 GMT

@niveditakumari

try this

Also make sure notification and event are on sys_user table

Is that user having notification preference enabled?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 07:30:31 GMT

Hi @Sai_Charan_K,

I'm printing Jday,Jmonth. It is printing Jmonth correctly but in Jday it is taking day and time.

Can you please help me to correct that.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 07:42:53 GMT

Hi @Ankur Bawiskar,

It is not working.

Can you please help me to correct that.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 08:07:10 GMT

Hi @Ankur Bawiskar,

Can you please help to correct code.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

Sai_Charan_K — Mon, 16 Dec 2024 08:37:54 GMT

Hi @niveditakumari ,

Adjusted the code to below as I wasn't aware that your "Date Of Joining" field was not a date field.

var gr = new GlideRecord("sys_user"); gr.addQuery("active=true^u_date_of_joiningISNOTEMPTY"); // Query for active users with a joining date gr.query(); while (gr.next()) { var jdate = new GlideDateTime(gr.u_date_of_joining); // Parse u_date_of_joining var to_date = new GlideDateTime(); // Current date gs.print(jdate.getDayOfMonth()); // Compare day and month if (to_date.getMonthUTC() == jdate.getMonthUTC() && to_date.getDayOfMonth() == jdate.getDayOfMonth()) { gs.print("Hi, it's the user's joining date anniversary!"); gs.eventQueue("joining.notification", gr, gr.name.toString(), gr.email.toString()); } }

Please try using this script and let me know if there are any further issues.

Please mark this solution as "Helpful" and "Accepted Solution" if this solution helped you in any way.

Thanks and Regards,
K. Sai Charan
Sr. ServiceNow Developer
Deloitte India

Re: I need to send notification on employee work anniversary.

Ankur Bawiskar — Mon, 16 Dec 2024 09:02:20 GMT

@niveditakumari

seems the field is empty for the user record

are you sure the field name is correct?

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 09:29:21 GMT

Hi @Sai_Charan_K,

Thank you so much for all your help. It is working as expected.

It is printing correct in background script but when I'm executing that in schedule job manually it is not showing logs with notification subject line in emails and logs in events.

Can you please help me for that.

Regards,

Nivedita A

Re: I need to send notification on employee work anniversary.

Sai_Charan_K — Mon, 16 Dec 2024 09:58:12 GMT

Hi @niveditakumari ,

I think this is because of the cross scope privileges issues.

Did you try checking the giving the cross scope privileges? If not please do as you are access global scope data from HR scope. Please go to the table : sys_scope_privilege.LIST and check for the record with your schedule job name or create a new record under this table to allow the access.

Please mark this solution as "Helpful" and please mark it "Correct" and close the thread so that it benefits future readers.

Thanks and Regards,
K. Sai Charan
Sr. ServiceNow Developer
Deloitte India

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 10:24:36 GMT

Hi @Sai_Charan_K,

Should I create notification and schedule job in global scope as I'm accessing global data.

Can you please confirm on that.

Regards,

Nivedita

Re: I need to send notification on employee work anniversary.

niveditakumari — Mon, 16 Dec 2024 11:41:26 GMT

Hi @Sai_Charan_K,

Should I create notification and schedule job in global scope.

Can you please confirm on that.

Regards,

Nivedita