Need help with background script to change the state of Change from review to closed in Change request table

Kaushik4
Giga Contributor

Hi Experts,

I need help on background scripting of 5 different change number for change state from review to closed in the change request table.

Change number is like change_request.numberINCHG0010144,CHG0010139,CHG0010138,CHG0010127,CHG0010126.

Thanks 

Kaushik

 

1 ACCEPTED SOLUTION

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Kaushik,

Here you go.

var numarray = ["CHG0010144","CHG0010139","CHG0010138","CHG0010127","CHG0010126"];
for (var i = 0; i < numarray.length; i++){
var gr = new GlideRecord("change_request");
gr.addQuery('number', numarray[i]);    
gr.query();
while(gr.next()){
gr.state = '3';
gr.setWorkflow(false);
gr.update();
}
}

- Pradeep Sharma

View solution in original post

7 REPLIES 7

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Kaushik,

Here you go.

var numarray = ["CHG0010144","CHG0010139","CHG0010138","CHG0010127","CHG0010126"];
for (var i = 0; i < numarray.length; i++){
var gr = new GlideRecord("change_request");
gr.addQuery('number', numarray[i]);    
gr.query();
while(gr.next()){
gr.state = '3';
gr.setWorkflow(false);
gr.update();
}
}

- Pradeep Sharma

Kaushik4
Giga Contributor

Thanku Experts for helping me.

You are very welcome Kaushik. Thanks for the update.