Hi Tony,

There are a number of possible methods for accomplishing this, depending on your specific business needs. Examining them is probably beyond the scope of this blog. We’d recommend that you post your question on the ServiceNow Community Forum.

Thank you!

There’s a little trick you need to use when pushing items into an array from a GlideRecord query. Add ‘toString()’ to the end of all of the items you’re pushing into the array like this…

answer.push(emeacm.user.toString());

answer = [];
var amer = current.u_amer;
var apac = current.u_apac;
var emea = current.u_emea;

if (amer == true){
var amercm = new GlideRecord(‘sys_user_grmember’);
amercm.addQuery(‘group.name’,’Change Manager’);
amercm.addQuery(‘user.u_region’,’AMER’);
amercm.query();
while(amercm.next()){
answer.push(‘amercm.user’);
}
}

if (apac == true){
var apaccm = new GlideRecord(‘sys_user_grmember’);
apaccm.addQuery(‘group.name’,’Change Manager’);
apaccm.addQuery(‘user.u_region’,’APAC’);
apaccm.query();
while(apaccm.next()){
answer.push(apaccm.user);
}
}
if (emea == true){
var emeacm = new GlideRecord(‘sys_user_grmember’);
emeacm.addQuery(‘group.name’,’Change Manager’);
emeacm.addQuery(‘user.u_region’,’EMEA’);
emeacm.query();
while(emeacm.next()){
answer.push(emeacm.user);
}
}

That’s right. If you aren’t pulling all of the members of the group in, it should be treated as a user approval rather than a group approval. There’s no way I know of to do what you want with a group approval activity within a workflow. I suppose you could set up a business rule on the ‘sysapproval_approver’ table to abort the insertion of approval records for users who should not approve, but I’m not sure how that will scale across different workflows.

Ahhhh ok, soo if i do this in a user approval activity….. my script looks like this below

answer = [];
var stream_sys_id = current.u_deal_business_stream;
var list = current.u_selected_stream_approvers.toString();
var gr = new GlideRecord(‘u_deal_business_stream’);
gr.addQuery(‘sys_id’,’=’,stream_sys_id);
gr.query();
if(gr.next())
{
var group = gr.u_business_stream;
answer.push(group); < -----Group ID } var grm2 = new GlideRecord('sys_user_grmember'); grm2.addQuery('group','=', group); grm2.addQuery('user','=' '23rd2e3e23e23e23e23ee32fwewe3') grm2.query(); if(grm2.next()) { answer.push(grm2.user); <-------User ID } But thing is, it does'nt create the group approval..... just create the user approval......