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