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.