Rollback background
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2023 01:43 AM
Hello,
I used the following background to change a request state
var SOURCE_REQUESTS =['REQ0010027'];
var requestGR = new GlideRecord('sc_request');
requestGR.addQuery('number' , 'IN' , SOURCE_REQUESTS);
requestGR.setValue('state' , 3);
requestGR.setValue('request_state' , 'closed_complete');
requestGR.setValue('stage' , 'closed_complete');
requestGR.setValue('description',' 4/7/23 - Bulk closure of old tickets');
requestGR.setWorkflow(false);
requestGR.updateMultiple();
var requestItemGR = new GlideRecord('sc_req_item');
requestItemGR.addQuery('request.number' , 'IN' , SOURCE_REQUESTS);
requestItemGR.addActiveQuery();
requestItemGR.setValue('state' , 3);
requestItemGR.setValue('stage' , 'Completed');
requestItemGR.setValue('active', false);
requestItemGR.setWorkflow(false);
requestItemGR.updateMultiple();
var taskGR = new GlideRecord('sc_task');
taskGR.addQuery('request.number' , 'IN' , SOURCE_REQUESTS);
taskGR.addActiveQuery();
taskGR.setValue('state', 3);
taskGR.setWorkflow(false);
taskGR.updateMultiple();
var cataskGR = new GlideRecord('consume_asset_task');
cataskGR.addQuery('request.number' , 'IN' , SOURCE_REQUESTS);
cataskGR.addActiveQuery();
cataskGR.setValue('state', 3);
cataskGR.setValue('active', false);
cataskGR.setWorkflow(false);
cataskGR.updateMultiple();
Instead of changing one record, it changed the states of 2 dozen records. I tried using the rollback function in servicenow but the requests are still in a state of closed complete.
Is there any way for me to change the state of the request records back to their original states?