Hi,
I have the catalog form where there are 2 reference fields.
1. user_to_be_released - reference of sys_user table
2. computer_name - reference of alm_hardware table
Now i need to auto populate the asset assigned to the user( "user_to_be_release field") in computer_name field and below are the CS and script include which i have written. But i didnt get any values returned in computer_name field.
Can you please help me with this and is there any reference qualifier needs to added in computer_name field? Please give your suggestions, since i am new to scripting.
Client Script - written on computer_name and type is onChange
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
// Client script for auto-populating computer name on change
var ga = new GlideAjax('GetAssetName');
ga.addParam('sysparm_name', 'getAssetName');
ga.addParam('sysparm_req', newValue);
ga.getXML(GetAssetNameParse);
function GetAssetNameParse(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
g_form.setValue('computer_name', answer);
}
Script Include - client callable
var GetAssetName = Class.create();
GetAssetName.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getAssetName: function() {
var req = this.getParameter('sysparm_user_to_be_released');
var gr = new GlideRecord('alm_hardware');
gr.addQuery('assigned_to', req);
gr.addQuery('model_category','Computer');
gr.query();
if (gr.next()) {
return gr.asset_tag; // returning the sys_id ensures that all fields in the reference are retrieved
}
},
type: 'GetAssetName'
});
