Good point Erik. We were wondering if this script is smart enough to check if there are any open RITMs under the parent REQ. I'm hoping SN is thinking of this too.
We ended up writing a scripted report to get all the active REQs where there is one and only 1 closed RITM.
With the report, we'd be able to see which REQ is still open where the RITM is still active.
Here's the script include:
var RITM_Check_Report = Class.create();
RITM_Check_Report.prototype = {
initialize: function() {
},
checkReport: function(){
var requests = [];
var check = 'false';
var gr = new GlideRecord('sc_request');
gr.addQuery('active',true);
gr.query();
while(gr.next()){
var rId = gr.sys_id.toString();
var ritmCheck = this.checkRITMs(rId);
if(ritmCheck === 'true'){
requests.push(rId.toString());
}
}
return requests;
},
checkRITMs: function(rId) {
var gr = new GlideRecord('sc_req_item');
gr.addEncodedQuery('active=false^request='+rId);
gr.query();
var ritmCount = gr.getRowCount();
if(ritmCount == 1){
return 'true';
}
},
type: 'RITM_Check_Report'
};
Seems to get us what we need.
