Hi Anand,
To do this you need to understand that you want to get server side data which is Requester details form User table and then populate it on Client side which is catalog item variables.
Now to do this you need a Script Include to fetch Server Side data and then pass it on to the Client Script which will populate the fields with client data.
Below is an example of Client callable Script Include:
var GetUserDetails = Class.create();
GetUserDetails.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getRequestor: function(){
var requestor= this.getParameter('requestor'); //sys_id of Requestor passed from Client script
var grUser= new GlideRecord('sys_user');
grUser.get(requestor);
var user= {};
user.Name= grUser.getValue('name');
user.Email= grUser.getValue('email');
//Add more fields for which you want value like above
return JSON.stringify(user);
},
Example of onChange Catalog Client script that will run on change of Requestor variable:
var ga = new GlideAjax('global.GetUserDetails');
ga.addParam('sysparm_name','getUser');
ga.addParam('user',newValue);
ga.getXMLAnswer(getResponse);
function getResponse(response){
var res = JSON.parse(response);
g_form.setValue('name',res.Name);
g_form.setValue('email',res.Email);
//Add more variable names and follow above pattern in function
}
If my answer helps then please mark it Helpful or Correct!
Thanks,
Utpal
