Convert Client script to Glide Ajax

[Maxwell3]

Hello all,

I am trying to convert this client script into a Glide Ajax call. This is located on this incident table and the incident form is taking a long time to load when updating the fields. I think a Glide Ajax call to a Script Include might help.

Here is the Client Script below.

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading)
return;

//make work notes mandatory as appropriate
if(newValue == oldValue)
g_form.setMandatory('work_notes', false);
else
g_form.setMandatory('work_notes', true);

//clear dependent values
g_form.setValue('assigned_to', null);
g_form.setValue('u_field3', null);
g_form.setValue('u_field2', null);
g_form.setValue('u_field1', null);

//repopulate dependent values
var group = g_form.getReference('assignment_group', setQueue);
}

function setQueue(group) {
if (group)
{
g_form.setValue('u_field1', group.u_field1);
g_form.setValue('u_field2', group.u_field2);
g_form.setValue('u_field3', group.u_field3);
}
}

[Maxwell3]

Thank you Ankur for your reply.

The script you provided came very close to a solution but unfortunately, it did not produce any values. In any other scenarios, I am sure it would've worked. Just an FYI, I had to make some adjustments. Below is the updated script, please let me know if this is ServiceNow best practice. I had to just keep tweaking it until it worked.

getRef: function() {

var group = this.getParameter('sysparm_group');
var groupRec = new GlideRecord('sys_user_group');
groupRec.addQuery('sys_id', group);
groupRec.query();
if (groupRec.next()) {
var obj = {};

//obj['u_field1'] = groupRec.u_field1;
//obj['u_field2'] = groupRec.u_field2;
//obj['u_field3'] = groupRec.u_field3;

//Updated script below

obj.u_field1 = groupRec.getDisplayValue('u_field1');
obj.u_field2 = groupRec.getDisplayValue('u_field2');
obj.u_field3 = groupRec.getDisplayValue('u_field3');
}
return JSON.stringify(obj);
},

[Ankur Bawiskar]

Hi Maxwell,

Script looks fine

small change ; declare the obj variable outside the scope of if statement

getRef: function() {

var obj = {};
var group = this.getParameter('sysparm_group');
var groupRec = new GlideRecord('sys_user_group');
groupRec.addQuery('sys_id', group);
groupRec.query();
if (groupRec.next()) {

//obj['u_field1'] = groupRec.u_field1;
//obj['u_field2'] = groupRec.u_field2;
//obj['u_field3'] = groupRec.u_field3;

//Updated script below

obj.u_field1 = groupRec.getDisplayValue('u_field1');
obj.u_field2 = groupRec.getDisplayValue('u_field2');
obj.u_field3 = groupRec.getDisplayValue('u_field3');
}
return JSON.stringify(obj);
},

Regards
Ankur

[The SN Nerd]

Be sure to return the display value of the reference field, otherwise your code is not much better than getReference().

If you don't, ServiceNow automatically makes a synchronous GlideAjax call back to the server to get the display value.

If you are lazy, download my share app that is the same as getReference but returns a display value

SmartAjax

[Maxwell3]

Hello Paul,

Thank you for providing this link. It makes sense, I updated the script as follows, but I still get the same result.

g_form.setValue('u_field1', answerObj.u_field1, answerObj.getDisplayValue('u_field1'));

g_form.setValue('u_field2', answerObj.u_field2, answerObj.getDisplayValue('u_field2'));

g_form.setValue('u_field3', answerObj.u_field3, answerObj.getDisplayValue('u_field3'));

[The SN Nerd]

Could be an ACL issue, that the user does not have read access to that record or field.