Cancel Requests which are pending approval for more than 3 months

Aakash Shah4 · ‎07-12-2017

Hi Guys,

I have a requirement to cancel all the requests which are pending approval for more than 3 months without sending email notifications.

The email notifications are applied on the sc_request table for both, request approved or rejected.

Any help is appreciated.

Aakash Shah4 · ‎07-13-2017

Thanks Guys for you help, i found the solution.

Created a Schedule Job :

var gr = new GlideRecord("sysapproval_approver");

gr.addQuery('sysapproval.sys_class_name','sc_request');

gr.addQuery('state','requested');

gr.addQuery('sys_created_on','<',gs.daysAgo(90));

gr.query();

while (gr.next()) {

gr.state = 'not_required';

cancelRequest(gr.sysapproval.number);

gr.update();

}

function commentParent(reqNum) {

var scReq = new GlideRecord("sc_request");

scReq.addQuery('number',reqNum);

scReq.query();

if(scReq.next()){

scReq.state = 4;

scReq.stage = 'closed_incomplete';

scReq.request_state = 'closed_cancelled';

scReq.update();

}

Anurag Tripathi · ‎07-12-2017

gr.addQuery('sysapproval.sys_class_name','sc_request');

-Anurag

Aakash Shah4 · ‎07-12-2017

Thanks Anurag,

That was perfect.

Now how can we cancel or close incomplete those request

Anurag Tripathi · ‎07-12-2017

that would be just a similar script where you loop through the sc_request and change its state to cancelled.

-Anurag

Aakash Shah4 · ‎07-12-2017

Could you please help me with the script

Harsh Vardhan · ‎07-12-2017

Hi Aakash,

Please check the thread below.