How to send emails to all group members from sys_user_group

[Priyanka77]

Hi,
There is one table in which there is a field "assignment group" which is referencing to "sys_user_group" and i need to send 4 same emails to group members mentioned in current group. Below is the email script written but still its coming empty in preview email. It should look like in email "Hi name(name of that group member)" for 4 users
var Arr=[];
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('sys_id', 'current.group'); 
gr.query();
while (gr.next()) {
Arr.push(gr.user.name.getDisplayValue()); 
}

Can someone suggest some solutions.
Thanks in advance.
Priyanka

[Sagar Pagar]

Hi,

Update your line as

gr.addQuery('group', current.your_group_field_name); 

Thanks,
Sagar Pagar

[Priyanka77]

Thanks for your response

Updated the below script but still its coming as empty.

var Arr=[];
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group', 'current.group'); 
gr.query();
while (gr.next()) {
Arr.push(gr.user.name.getDisplayValue()); 
}

[Sagar Pagar]

Hi,

remove quotes

gr.addQuery('group', current.group); 

Thanks,

Sagar Pagar

[Priyanka77]

Apologies for the quotes in the comment. I have tried without quotes only in my script but still its not working.