Hi @Ashish Khairnar ,
Please don't use getReference due to performance reasons. See e.g. https://www.servicenow.com/community/developer-forum/which-approach-is-best-getreference-or-glideaja...
I created a simple generic function so you can reuse it for every getValue retrieval via GlideAjax.
The script include is called "ajaxGetFieldValues" and the function "getValues", which is accepting 3 params (tableName, fieldNames end sysId).
It will retrieve the fieldValues for the given table/sys_id and returns it as an object. You can retrieve multiple values at once. It returns both value and displayValue.
var ajaxGetFieldValues = Class.create();
ajaxGetFieldValues.prototype = Object.extendsObject(AbstractAjaxProcessor, {
/*
Get the values of the specified fields for the specified table
Input :
- tableName
name : sysparm_tableName
type : string
example : "incident"
- fieldNames
name : sysparm_fieldNames
type : string -> comma seperated list
example : "number, short_description"
- sysId
name : sysparm_sysId
type : string
example : "800b174138d089c868d09de320f9833b"
*/
getValues : function(tableName, fields, sysId){
tableName = this.getParameter("sysparm_tableName") || tableName;
fields = this.getParameter("sysparm_fieldNames") || fields;
sysId = this.getParameter("sysparm_sysId") || sysId;
var returnObj = [];
try{
var fieldsObj = fields.split(",");
var gr = new GlideRecord(tableName);
//Validate the existence of the table
if(gr.isValid()){
//Retrieve the record
if(gr.get(sysId)){
for(var i = 0; i < fieldsObj.length; i++){
//Validate the existence of the field
if(gr.isValidField(fieldsObj[i])){
returnObj.push({"fieldName" : fieldsObj[i], "value" : gr.getValue(fieldsObj[i]), "displayValue" : gr.getDisplayValue(fieldsObj[i])});
}
}
return JSON.stringify(returnObj);
}
}
return "[]"
}catch(e){
return "[]";
}
},
type: 'ajaxGetFieldValues'
});
Example client script, where I retrieve only the manager field of the user you've pushed into the assigned_to field.
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}
var ga = new GlideAjax('global.ajaxGetFieldValues');
ga.addParam('sysparm_name', 'getValues'); //name of your function
ga.addParam('sysparm_tableName', "sys_user");
ga.addParam('sysparm_fieldNames', "manager"); //the fieldnames, comma separated
ga.addParam('sysparm_sysId', newValue); //the sysId of the record you want to retrieve
ga.getXMLAnswer(function(answer) {
var result = JSON.parse(answer);
var resultLength = result.length;
debugger;
if(result && resultLength > 0){
for(var i = 0; i < resultLength; i++){
//your logic to push the values into the right fields
//e.g. the manager should be set into the description field
if(result[i].fieldName == 'manager'){
g_form.setValue('description', "The value of the manager is : " + result[i].value + ", and the displayValue is " + result[i].displayValue);
}
}
}
});
}
I also attached the examples as XML, so you can import them in your PDI to check them out.
Of course you can simplify it even more, by just retrieving the manager, but that would give you work every time you need a value via GlideAjax.
Regards,
Hayo
Please hit like and mark my response as correct if it solved your issue
