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

still same not sure where its having issues tried different scenarios

Ram050670 · ‎10-17-2023

i have also tried like this to get the groups (its working) but its giving the Parent of the group also.

FYI may be we can modify that?

javascript&colon;'typeLIKE sys_ID of type^sys_idIN' + new global.ArrayUtil().convertArray(gs.getUser().getMyGroups());

Uday Soni05 · ‎10-17-2023

Update the Code for Reference Qualifier as below :

javascript&colon; new CatalogClientUtil().getUserRequestGroups(gs.getUserID());

And Script Include like this:

getUserRequestGroups: function(userId) {

var groups = [];

var gr = new GlideRecord('sys_user_grmember');

gr.addQuery('user', userId);

gr.addQuery('group.type', 'sys_id of your group type request');

gr.query();

while (gr.next()) {

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

}

return 'sys_idIN' + groups;

},

It should work

Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday

Uday Soni05 · ‎10-17-2023

Just try this once and let me know

Ram050670 · ‎10-17-2023