Get User groups list from Requested For

[Ram050670]

Hi All,

i would like to get List of groups (type = request) of user from requested for to a reference type field.

can someone help me with Script include and advanced reference qualifier.

Thanks in advance!

[Anand Kumar P]

Hi @Ram050670,

Script include script-

getUserRequestGroups: function(userId) {
var groups = [];
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('user', userId);
gr.addQuery('group.type', 'request');
gr.query();
while (gr.next()) {
groups.push(gr.group.toString());
}
return groups;
},

Reference qualifier script in user group list field-

javascript: new GroupUtils().getUserRequestGroups(current.user.toString())
Please mark it as solution proposed and helpful if it works for you.

Thanks,

Anand

[Ram050670]

tried but not working, showing all groups

[Harsh_Deep]

Hi @Ram050670 

Script include script-

getUserRequestGroups: function(userId) {

var groups = [];

var gr = new GlideRecord('sys_user_grmember');

gr.addQuery('user', userId);

gr.addQuery('group.type', 'request');

gr.query();

while (gr.next()) {

groups.push(gr.group.toString());

}

return 'sys_idIN'+groups;

},

Reference qualifier script in user group list field-

javascript: new GroupUtils().getUserRequestGroups(current.variables.name.toString())

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.👍

[Ram050670]

i actually tried that too! req backend is name.