Script to Change change request is not Working

[rahuls1]

Hi Experts,

I need your help. I have a requirement to cancel change requests Type=Standard, State=Draft and Active=True.

Then update close notes and Implementation status.

(There are 480 change records)

My Script:

var gr = new GlideRecord("change_request");
gr.addQuery('type=Standard^state=-22^active=true');
gr.query();
while(gr.next()){
gr.state = '4';
gr.u_implementation_status = 'cancelled';
gr.setValue( 'close_notes' , 'Cancelling change due to aging');
gr.update();
}

When I run the above background script only 1 change records is cancelled out of 480 records. If my script has any errors please help me out. I have attached the pic after running background script.

[Saurav11]

Hello,

You need to use addEncodedQuery instead of addQuery

Please use the below script:-

var gr = new GlideRecord("change_request");
gr.addEncodedQuery('type=Standard^state=-22^active=true');
gr.query();
while(gr.next()){
gr.state = '4';
gr.u_implementation_status = 'cancelled';
gr.setValue( 'close_notes' , 'Cancelling change due to aging');
gr.update();
}

Please mark my answer as correct based on Impact.

[rahuls1]

Hi Saurav11

Thanks for your response. But unfortunately it didn't work. Still only one records gets updated. I am not sure why. 

[Saurav11]

Hello,

Use gr.setWorkflow(false) so use the below code

var gr = new GlideRecord("change_request");
gr.addEncodedQuery('type=Standard^state=-22^active=true');
gr.query();
while(gr.next()){
gr.setWorkflow(false)
gr.state = '4';
gr.u_implementation_status = 'cancelled';
gr.setValue( 'close_notes' , 'Cancelling change due to aging');
gr.update();
}

Please mark my answer as correct based on Impact.

[Saurav11]

Also I would suggest to change the 'gr' variable to to something else like cr or change request or anything