Hi,
In this article, I will show you how we can automatically select the values in the list collector variable.
Requirement: When you select a group, under user list collector, select all the group members dynamically.
Create 2 reference fields in your catalog item
- Group : Reference field (reference to sys_user_group)
- Members: List collector field (reference to sys_user_grmember)
OnChange Client Script on Group field
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
//pass the group to SI and get members of that group
var ga = new GlideAjax("getSelectedGroupMembers");
ga.addParam("sysparm_name","getMembers");
ga.addParam("sysparm_group",newValue); //pass the group sys_id to SI
ga.getXML(parseResponse);
}
function parseResponse(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
if(answer !=0) {
answer=answer.split(",");
g_form.clearValue("members");
g_form.setValue("members",answer);
} else {
g_form.clearValue("members");
}
}
Script Include
Name: getSelectedGroupMembers
Active: True
Client Callable: True
var getSelectedGroupMembers = Class.create();
getSelectedGroupMembers.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getMembers:function() {
var group = this.getParameter("sysparm_group").toString();
var gr = new GlideRecord("sys_user_grmember");
gr.addQuery("group",group); //query the group members based on selected group
gr.query();
var members=[];
while(gr.next()) {
members.push(gr.getValue("user"));
}
if(members.length>0)
return members.toString();
else
return 0;
},
type: 'getSelectedGroupMembers'
});Output (Service Portal)
Output (Backend)
Let me know if you have any questions in the comments below.
Mark the article as helpful and bookmark if you found it useful.
Regards,
Asif
2020 ServiceNow Community MVP
