Reference Qualifier for assignment group depending on Assigned to field.

LakshmiNarayan7 · ‎08-25-2019

After choosing the Assigned To field, the Assignment Group should show only the group of assigned to user.

Ankur Bawiskar · ‎08-25-2019

Hi Lakshmi,

you are sending assigned_to value as parameter to the function from the ref qualifier but as per the function declaration it doesn't accept any parameter

so make these changes

1) make the function accept parameter

2) remove line number 7

3) in line number 9 use below; don't put quotes around the variable

gr.addQuery('user', a);

4) also use while instead of if in line number 11

5) while returning the array use join method

updated script

assignmentGroup: function(a){

var arryVal = [];

var gr = new GlideRecord('sys_user_grmember');

gr.addQuery('user',a);

gr.query();

while(gr.next()){

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

}

return 'sys_idIN' + arryVal.join(',');

},

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

LakshmiNarayan7 · ‎09-06-2020

Thanks a lot!