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!
1 ACCEPTED SOLUTION
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: new catalogClientUtil().getUserRequestGroups();
Hello @Ram050670
Use this Script include
getUserRequestGroups: function(userId) {
var groups = [];
var gr = new GlideRecord('sys_user_grmember');
gr.addEncodedQuery('user='+userId+'^group.typeLIKE'+sys_id_of_request record);
gr.query();
while (gr.next()) {
groups.push(gr.group.toString());
}
return 'sys_idIN'+groups;
},
Use the sys_id of this record which you have sent on above
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Didn't work!
