Hi,
Requirement:
I am trying to make an onChange script call a script include which queries the group member table for the group members of a particular group(field on the form). That script include sends back a list of users for a user table reference field on the form. I want the user field to have only this list of users available for selection.
Issue:
The response which I get from the Script include simply gets pasted in the text area of the reference field. How do I make the User table reference field options filtered to the list of user received in response.
ScreentShot:
Script Include:
var MyScript = Class.create();
MyScript.prototype = Object.extendsObject(AbstractAjaxProcessor, {
MyFunction: function(group){
var userList = [];
var grpValue = this.getParameter('sysparm_gname');
gs.log('1');
var grp = new GlideRecord('sys_user_grmember');
gs.log('2');
grp.addQuery('group',grpValue);
gs.log('3');
grp.query();
gs.log('4');
/* var grp = new GlideRecord('sys_user_grmember');
grp.addQuery('group',group);
grp.query();*/
while(grp.next()) {
//anArray.length == 0
/* if (userList.length != 0) {
userList += (',' + grp.user);gs.log('Loop1');
}
else {
userList = grp.user;gs.log('Loop2');
}*/
// userList.push(grp.user.toString());
userList.push(grp.getDisplayValue('user'));
gs.log('Loop');
}
gs.log('@@@Test:::: ' + userList);
return userList.join();
//return 'sys_idIN' +userList.join();
// return '' + userList;
},
type: 'MyScript'
});
Client Script:
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue== '') {
//Make server call
g_form.setValue('grp_mmbr_ref', '');
return ;
}
if (newValue != oldValue) {
//Make server call
var ga = new GlideAjax('MyScript');//this is the script include
ga.addParam('sysparm_name','MyFunction'); //this is the function within the script include
ga.addParam('sysparm_gname', g_form.getValue('test_item_grp_ref'));
ga.getXML(getResponse);
return;
}
function getResponse(response) {
var values = response.responseXML.documentElement.getAttribute('answer').toString().split(',');//.split('|');
g_form.setValue('grp_mmbr_ref', values);
/*g_form.setValue('description', values[1]);*/
}
}
Before we focus on the technical issue, let's focus on the solution. Do you want to pick one person from the team or do you want to pick many people from the team.
In most cases with a reference field, you don't need an onChange client script to do the filtering for you, you want a reference qualifier. See the example image below.
