Notify Employee Before 2 days of End Date in Catalog Item

[PratikshaAbhang]

Hi ServiceNow Community,

I'm in need of some help with a Maintain Item.

 my requirement is  : End Date is 10 march then send email 2 days before[8 March] to Employee Name 

Thanks,

Pratiksha

[Anurag Tripathi]

Hi,

You can write a scheduled job that runs once a day,  checks all Active tickets created by that catalog item and looks if the variable due date is 2 days from now, send an email for the tickets that come in the result set.

[PratikshaAbhang]

I am trying to figure out filter condition on SC_REQ_ITEM table in order to find variable names "End Date" & "Employee Name"  but couldn't find any way to do that.

Can you please provide filter condition screenshot or way of doing it?

[Anurag Tripathi]

Try this

var getData = new GlideRecord('sc_req_item');
getData.addEncodedQuery('cat_item=<catalog item sys_id>^variables.<Variable Sys_id>RELATIVEGT@dayofweek@ahead@1^variables.<Variable Sys_id>RELATIVELT@dayofweek@ahead@3^active=true');
getData.query()
while(getData.next())
{
//do whatever
}

Add the right catalog item sys_id and variable sys id 

[Dr Atul G- LNG]

Hi @PratikshaAbhang 

https://www.servicenow.com/community/developer-forum/send-notification-only-15-days-before-the-due-d...

This will be helpful.

You can use Flow

Trigger

Action

Look up record

Due date relative 2 days before