Hi Madhuri,
Please follow the below steps:
1. Create a Schedule(here you can exclude holidays as well) like below:
2. Create a Scheduled Job that will execute daily on your time choosing.
3. Paste the script below in the run script section.
var grAprvl = new GlideRecord('sysapproval_approver');
grAprvl.addEncodedQuery('state!=approved^sys_created_on'); // check for all records with the state not 'Approved'
grAprvl.query();
while (grApp.next()) {
var grCustom = new GlideRecord('custom_table'); // find the appropriate record
grCustom.addQuery('approval_field', grAprvl.sysapproval); //the field 'Approval for'
grCustom.query();
if (grCustom.next()) {
var sched = new GlideSchedule('090eecae0a0a0b260077e1dfa71da828');
var created = grCustom.sys_created_on;
var gdt = new GlideDateTime();
var gtime1 = new GlideDateTime(created); //passing created on date to the GlideDateTime object
gtime1.addDays(6); //adding 6 days to the created on date
var dur = GlideDateTime.subtract(gdt, gtime1); //the difference between todays date and date after 6 days record was created
var result = dur.getNumericValue();
if (sched.isInSchedule(gdt) /*checking if todays date is in schedule*/ && result < 0 /*checking if 6 days has passed*/ ) {
grCustom.u_state = 'cancelled'; // set state to 'cancelled' on custom table
grCustom.update();
}
}
}
Please mark correct if find it helpful.
