Get User groups list from Requested For

Ram050670 · ‎10-17-2023

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!

Ram050670 · ‎10-19-2023

I would say this is the right way to do it on this request!!

--------------Script Include------------------------

getUserRequestGroups: function(userId) {

var Gtype = gs.getProperty("Assignment_Group_Type");

var gFilter = gs.getProperty("Assignment_Group_Dynamic_user");

var groups = [];

var gr = new GlideRecord('sys_user_grmember');

gr.addEncodedQuery('group.typeLIKE' + Gtype + '^userDYNAMIC' + gFilter);

gr.query();

while (gr.next()) {

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

}

return 'sys_idIN' + groups;

},

-----------------------Reference Qualifier-------------------------

javascript&colon; new catalogClientUtil().getUserRequestGroups();

Ram050670 · ‎10-17-2023

Harsh_Deep · ‎10-17-2023

In the Reference qualifier don't use javascript&colon; new

Use this-

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

Uday Soni05 · ‎10-17-2023

hI @Ram050670;
Update your Reference Qualifier to :

javascript&colon; new CatalogClientUtil().getUserRequestGroups(current.variables.requested_for.toString())

Don't put &colon; put actual colon

Ram050670 · ‎10-17-2023

tried this too! didn't work.

Uday Soni05 · ‎10-17-2023

@Ram050670,
Update your Script Include to return 'sys_idIN'+groups;

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;

},