The CreatorCon Call for Content is officially open! Get started here.

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.