I want to get list of users based on one group

[sailakshmi]

I have one list type field >> If I go and search it has to show particular group members 

for that I stored sys_id of that group in  system property 

can any one help me

[Shakeel Shaik · Accepted solution]

Hi @sailakshmi 

Add Reference Qualifier to your List Type field:-

javascript: new <scriptIncludeName>.<functionName>;

 Script Include:-

functionName: function(){
var groupSys_id = gs.getProperty('<Property Name>');

var groupMem = new GlideRecord('sys_user_grmember');
 
groupMem.addEncodedQuery('group='+ groupSys_id);
groupMem.query();
var users = [];
while (groupMem.next()){
users.push(groupMem.user.toString());
 
}
return 'sys_idIN' + users.toString());​

},

If my response is helpful, then Please mark it as Correct Answer/Helpful.

Please check and let us know.

Thanks 🙂

Shakeel Shaik.

[sailakshmi]

Thanks

I will check & let you know

[sailakshmi]

Its working 

Tq shakeel shaik

[Jaspal Singh]

List Type field is reference to which table?

Group? Group-Membership?