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.

Create new dynamic filter for assigned to one of my group members

Thrupthi
Tera Expert

I tried creating the new dynamic filter for condition assigned to dynamic to one of my group members, but the result doesnt display correct members. can someone please help

 

Script include: 

 

function getMyGroupMembers(){
var myGroups = gs.getUser().getMyGroups();

var groupsArray = new Array();
var it = myGroups.iterator();
var i=0;
var groupMemberArray = new Array();
while(it.hasNext()){
var myGroup = it.next();
var grMem = new GlideRecord('sys_user_grmember');
grMem.addQuery('group', myGroup);
grMem.addQuery('user.active', true);
grMem.query();
while(grMem.next()){
groupMemberArray.push(grMem.user.toString());
}
i++;
}
return groupMemberArray;
}

 

12 REPLIES 12

Michael Fry1
Kilo Patron

Can you try with something like this:

var myGroups = gs.getUser().getMyGroups();
var groupMemberArray =[];

var grMem = new GlideRecord('sys_user_grmember');
grMem.addQuery('group','IN', myGroup);
grMem.addQuery('user.active', true);
grMem.query();
while(grMem.next()){
groupMemberArray.push(grMem.user.toString());
}
}
return groupMemberArray;

Hi Michael, Thanks for the reply but this doesnt work as well

I see a typo in the script. It should be myGroups

grMem.addQuery('group','IN',myGroups);

no luck Mike