GlideAggregate is not working

sudhir041 · ‎11-22-2022

I have a script and currently it is not working with GlideAggregate can someone please rectify it:

var RITM = new GlideRecord("sc_req_item");

RITM.addEncodedQuery("state=2"); //state is in progress

RITM.query();

while (RITM.next()) {

var p= 0;

var Task = new GlideAggregate("sc_task");

Task.addQuery("request_item", RITM.sys_id);

Task.addAggregate('COUNT');

Task.query();

var total = Task.getAggregate('COUNT');

while (Task.next()) {

if (Task.active.toString() == 'false') {

p++;

}

if (p == total && total != 0) {

gs.print(RITM.number);

}

Goran WitchDoc · ‎11-22-2022

Here is a script that can do that. Depending on the instance it's going for, amount of RITMs, active tasks and so on it might need to be tweaked. Perhaps even run as a flow instead and so on. I would also probably throw in some more checks in case there aren't any RITMs with state "in progress" or active tasks.

var RITM = new GlideRecord("sc_req_item");
RITM.addEncodedQuery("state=2"); //state is in progress
RITM.query();

var ritmSysids = [];
//Get all RITM sys_ids and put them in a array
while (RITM.next()) {
ritmSysids.push(RITM.getUniqueValue());
}    

var checkTasks = new GlideRecord('sc_task');
checkTasks.addQuery('request_item','IN',ritmSysids);
checkTasks.addQuery('active',true);
checkTasks.query();

//Go through active tasks and remove the RITM from the array since it should only contain
//RITM with no active tasks
while(checkTasks.next()){

ritmSysids = ritmSysids.filter(function(item) {
return item != checkTasks.request_item
})
}

gs.info("Sys_ids of RITM with no active tasks: " + ritmSysids)

View solution in original post

Mike_R · ‎11-22-2022

Try this

var ritm = new GlideRecord('sc_req_item');
ritm.addEncodedQuery('active=true^RLQUERYsc_task.request_item,=00^active=true^ENDRLQUERY');
ritm.query();
gs.print(ritm.getRowCount());
while(ritm.next()){
	gs.print(ritm.number);
}

Mike
* My Collection of ServiceNow Stuff *

sudhir041 · ‎11-22-2022

can i not use glide aggregate?

Mike_R · ‎11-22-2022

What are you trying to accomplish exactly? What's the end goal once you have the aggregate count?

Mike
* My Collection of ServiceNow Stuff *

sudhir041 · ‎11-22-2022

I need the RITM so instead of GlideRecord i wanted to go ahead with GlideAggregate.

Mike_R · ‎11-22-2022

The code I provided will give you that and also let you access the RITM details.

var ritm = new GlideRecord('sc_req_item');
ritm.addEncodedQuery('active=true^RLQUERYsc_task.request_item,=00^active=true^ENDRLQUERY');
ritm.query();
gs.print(ritm.getRowCount());
while(ritm.next()){
	gs.print(ritm.number);
}

Mike
* My Collection of ServiceNow Stuff *