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 ,
Your script include code is not correct. You are not returning correct query.
Please refer to the below code:-
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;
},
Also, for Reference Qualifier your script is incorrect , refer to the below script:
If this response clears up your doubt, kindly flag it as both helpful and correct.
Thanks,
Alka
