Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2021 09:18 PM
Hi,
below script should help
updateRecords();
function updateRecords(){
try{
var ritm = new GlideRecord("sc_req_item");
ritm.addActiveQuery();
ritm.addEncodedQuery("stage!=complete");
ritm.query();
while(ritm.next()){
//check for active sc tasks
var taskRec = new GlideRecord('sc_task');
taskRec.addActiveQuery();
taskRec.addQuery("request_item",ritm.sys_id);
taskRec.query();
if(!taskRec.next()){
//close requested item
ritm.stage = "complete";
ritm.active = false;
ritm.state = 3; // set to close complete
ritm.setWorkflow(false); // stop any BR
ritm.update();
//close request
var request = ritm.request.getRefRecord();
request.active = false;
request.state = 3;
request.setWorkflow(false);
request.update();
}
}
}
catch(ex){
gs.info('Exception'+ex);
}
}
Regards
Ankur
Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader