1 ACCEPTED SOLUTION
Hi,
So you will have to go with script approach
Script Include: It should be client callable
var ReportUtils = Class.create();
ReportUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getRITM:function(){
var arr = [];
var gr = new GlideRecord("sc_req_item");
gr.addEncodedQuery("state=1"); // state is open
gr.query();
while(gr.next()) {
var closedCount = 0;
var taskRec = new GlideRecord("sc_task");
taskRec.addQuery("request_item", gr.sys_id);
taskRec.query();
var totalCount = taskRec.getRowCount();
while(taskRec.next()){
if(taskRec.active.toString() == 'false'){
closedCount++;
}
}
if(closedCount == totalCount && totalCount != 0){
// if count is same then all tasks are closed then push RITM sys_id in array
arr.push(gr.getValue('sys_id'));
}
}
return arr.toString();
},
type: 'ReportUtils'
});Condition of Report
sys_id [IS ONE OF] javascript: new ReportUtils().getRITM();
Regards
Ankur
