Rollback background

jhwh
Tera Contributor

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?

0 REPLIES 0