- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2020 11:50 PM
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
Solved! Go to Solution.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2020 11:55 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2020 11:55 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2020 03:24 AM
Thanku Experts for helping me.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2020 03:33 AM
You are very welcome Kaushik. Thanks for the update.