I need to send notification on employee work anniversary.

[niveditakumari]

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 

[niveditakumari]

Hi @Sai_Charan_K, 

Can you please help me to create cross scope privileges. 

Regards, 

Nivedita 

[niveditakumari]

Hi @Sai_Charan_K, 

It is sending notification who is completing their anniversary on tomorrow.

Ex - Today is 4th Jan and I'm executing schedule job today then it is checking for tomorrow's hire date and sending notification for that user who is completing their anniversary on 5th Jan.

Can you please help me to fix that. 

Regards, 

Nivedita 

[Sai_Charan_K]

Hi @niveditakumari ,

Can you please share the script and scheduled job conditions which you have used ?

Thanks and Regards,

K. Sai Charan

[niveditakumari]

Hi @Sai_Charan_K, 

I have tested that and found that after executing schedule job it is sending notification whose is completing anniversary on 3rd Jan. I need to send notification only for exact anniversary. It is sending notification to +1 day like when I'm executing that today it is sending notification for today + 1 that is completing their anniversary on 3rd Jan but it should send notification who is completing anniversary on today. 

Please find attached screenshot : 

Can you please help me to send notification for exact day. 

Regards, 

Nivedita 

[Ankur Bawiskar]

@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:gs.beginningOfToday()@javascript: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.