Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

gs.eventqueue triggers event but state is error

ankitsharma_487
Giga Guru

Below is the code which triggers event but event's state turns to ERROR, please find screenshot also

var gr = new GlideAggregate("sysapproval_approver");
gr.addQuery("state", "requested");
gr.addAggregate("COUNT", "approver");
gr.query();
while(gr.next()){
	gs.eventQueue("send_approval_reminder",gr, gr.approver, gr.approver.getDisplayValue());
	
}

 

1 ACCEPTED SOLUTION

ankitsharma_487
Giga Guru

Hey guys, thanks all for your help and putting time into it, I was able to figure out this

I stored approver sys ids into an array and then looped it for triggering email.

That Worked

View solution in original post

18 REPLIES 18

Hi @ankitsharma_487 

 I am facing similar issue, Could you please post your solution here. 

 

Thanks,

Uma.

arr=[];
var ga = new GlideAggregate("sysapproval_approver");
ga.addQuery("state","requested");
ga.groupBy('approver'); 
ga.query();
while(ga.next()) {
arr.push(ga.approver.sys_id.toString());
}
 
 
 
 
for(var i = 0; i<=arr.length; i++)
{
var x= arr[i];
 
var gr = new GlideRecord('sys_user');
gr.get(x);
gs.eventQueue("send_approval_reminder",gr, gr.sys_id, gr.name);
 
 
 
}

 

@Pavani12 

 

please find below

arr=[];
var ga = new GlideAggregate("sysapproval_approver");
ga.addQuery("state","requested");
ga.groupBy('approver'); 
ga.query();
while(ga.next()) {
arr.push(ga.approver.sys_id.toString());
}
 
 
 
 
for(var i = 0; i<=arr.length; i++)
{
var x= arr[i];
 
var gr = new GlideRecord('sys_user');
gr.get(x);
gs.eventQueue("send_approval_reminder",gr, gr.sys_id, gr.name);
 
 
 
}

Pavani12
Tera Contributor

Hello @ankitsharma_487 

 

Please post your solution here, I am also facing similar issue.

 

Thanks,

Uma.