I want to get list of users based on one group

Go to solution
sailakshmi
Giga Contributor

‎06-08-2022 12:29 AM

 

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

 

0 Helpfuls
  • 1,541 Views
1 ACCEPTED SOLUTION

Go to solution
Shakeel Shaik
Giga Sage
Giga Sage

‎06-08-2022 12:35 AM

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.

Thanks,
Shakeel Shaik 🙂

View solution in original post

6 REPLIES 6

Go to solution
sailakshmi
Giga Contributor
In response to Jaspal Singh

‎06-08-2022 02:37 AM

 user table

0 Helpfuls

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

‎06-08-2022 12:51 AM

Hi,

Could you provide some details such as those which are asked by Jaspal

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls