How to send notifications before due dates

Sanket Pawar — Tue, 21 Nov 2023 19:02:02 GMT

Hi All,

I have a requirement where,

I have a date field value_date,and when I am working on a ticket that is in the "New status", notifications should be sent to requestor in below conditions:

1. Five business days before the value date

2. One business day before the value date

3. On the value date

4. One business day after the value date

I have created a schedule job to fulfill this requirement, but the schedule job is triggering notifications daily besides these condition,

ideally the schedule job should trigger notification only when the conditions in below function satisfy

for example if iam executing the function onedaybefore(),then the email is getting triggered everyday that should not be the case.

script:

fivedaysbefore();

onedaybefore();

currentday();

onedayafter();

function fivedaysbefore() {

var mn = new GlideRecord('x_cacei_s2p_payment');

mn.addEncodedQuery('u_value_dateRELATIVEGT@dayofweek@ahead@5^state=1^active=true');

mn.query();

while (mn.next()) {

gs.eventQueue('x_cacei_s2p.manualpayment',mn);

}

function onedaybefore() {

var mn = new GlideRecord('x_cacei_s2p_payment');

mn.addEncodedQuery('u_value_dateONTomorrow@javascript&colon;gs.beginningOfTomorrow()@javascript&colon;gs.endOfTomorrow()^state=1^active=true');

mn.query();

while (mn.next()) {

gs.eventQueue('x_cacei_s2p.manualpayment',mn);

}

function currentday() {

var mn = new GlideRecord('x_cacei_s2p_payment');

mn.addEncodedQuery('u_value_dateONToday@javascript&colon;gs.beginningOfToday()@javascript&colon;gs.endOfToday()^state=1^active=true');

mn.query();

while (mn.next()) {

gs.eventQueue('x_cacei_s2p.manualpayment',mn);

}

function onedayafter() {

var mn = new GlideRecord('x_cacei_s2p_payment');

mn.addEncodedQuery('u_value_dateONYesterday@javascript&colon;gs.beginningOfYesterday()@javascript&colon;gs.endOfYesterday()^state=1^active=true');

mn.query();

while (mn.next()) {

gs.eventQueue('x_cacei_s2p.manualpayment',mn);

}

Re: How to send notifications before due dates

Tony Chatfield1 — Tue, 21 Nov 2023 21:16:59 GMT

Hi, I suspect that your issue is you are not filtering for a period between dates.

IE for fivedaysbefore() your filter is 'u_value_dateRELATIVEGT@dayofweek@ahead@5'

but this needs to capture a window using before\after so that you only trigger fivedaysbefore() once per record (when fivedaysbefore() is run daily).

'start_dateRELATIVEGT@dayofweek@ahead@4^start_dateRELATIVELT@dayofweek@ahead@6'

/now/nav/ui/classic/params/target/change_request_list.do%3Fsysparm_query%3Dstart_dateRELATIVEGT%40dayofweek%40ahead%404%255Estart_dateRELATIVELT%40dayofweek%40ahead%406%26sysparm_first_row%3D1%26sysparm_view%3D

From experience, the best way to ensure that queries of this nature are correct.
is by configuring filters on a list view, ensure that you have sufficient sample data to cover all date variations.

question How to send notifications before due dates in CSM forum

How to send notifications before due dates

Re: How to send notifications before due dates