Auto Populate requested for a catalog item in service-now..

[surya65]

Please help me with the script includes and onchange client script to Populate requested for details while raising a request through catalog item.

Below are the variables from catalog item: need to auto populate   using user  table.

requested for--> reference field    (user table)

'employee id --> reference  field  (auto populate based on requested for user)

manager name------>reference field  (auto populate based on requested for user)

title------->reference field   (auto populate based on requested for user)

cost center---------->reference field  (auto populate based on requested for user)

application-------->reference field    (auto populate based on requested for user)

plz correct if any wrong in my code:

function onChange(control, oldValue, newValue, isLoading) {

                if (isLoading || newValue == '') {

                                return;

                }

 

                var ga = new GlideAjax('CheckRecords');

                ga.addParam('sysparm_name', "checkRecordPresent");

                ga.addParam('sysparm_userID', g_form.getValue('requested_for'));

                ga.getXMLAnswer(function(answer){

                                if(answer != 'not found'){

                                                var parser = JSON.parse(answer);

                               

                                                g_form.setValue('email', parser.email);

                                                g_form.setValue('employee_id', parser.employee);

                                                g_form.setValue('manager_name', parser.manager);

                                                g_form.setValue('title', parser.title);

                                                g_form.setValue('cost_center', parser.costcenter);

                                                g_form.setValue('application', parser.application);

                                               

                                               

                                               

                                               

                                               

                                               

                                }

                });

SCRIPT INCLUDE CODE:

var CheckRecords = Class.create();

CheckRecords.prototype = Object.extendsObject(AbstractAjaxProcessor, {

 

                checkRecordPresent: function(){

                                var obj = {};

                                var id = this.getParameter('sysparm_userID');           

                                var gr = new GlideRecord('sys_user');

                                gr.addQuery('sys_id', id);

                                gr.query();

                                if(gr.next()){

                                                obj['email'] = gr.getValue('email');

                                                obj['employee_id'] = gr.getValue('employee');

                                                obj['manager_name'] = gr.getValue('manager');

                                                obj['title'] = gr.getValue('title');

                                                obj['cost_center'] = gr.getValue('costcenter');

                                                obj['application'] =gr.getValue('application');

                                               

                                }

                                return JSON.stringify(obj);

                },

                type: 'CheckRecords'

});

[AnirudhKumar]

Your glideajax code is incorrect.

Check the below code:

var ga = new GlideAjax('HelloWorld');
ga.addParam('sysparm_name', 'helloWorld');
ga.addParam('sysparm_user_name', "Bob");
ga.getXML(HelloWorldParse);
 
function HelloWorldParse(response) {
  var answer = response.responseXML.documentElement.getAttribute("answer");
  alert(answer); }

[surya65]

hi kumar plz correct ware it goes wrong:

function onChange(control, oldValue, newValue, isLoading) {

                if (isLoading || newValue == '') {

                                return;

                }

 

                var ga = new GlideAjax('CheckRecords');

                ga.addParam('sysparm_name', "checkRecordPresent");

                ga.addParam('sysparm_userID', g_form.getValue('requested_for'));

                ga.getXMLAnswer(function(answer){

                                if(answer != 'not found'){

                                                var parser = JSON.parse(answer);

                               

                                                g_form.setValue('email', parser.email);

                                                g_form.setValue('employee_id', parser.employee);

                                                g_form.setValue('manager_name', parser.manager);

                                                g_form.setValue('title', parser.title);

                                                g_form.setValue('cost_center', parser.costcenter);

                                                g_form.setValue('application', parser.application);

                                               

                                               

                                               

                                               

                                               

                                               

                                }

                });

[Ankur Bawiskar]

Hi,

Changes

1) field name on user table is cost_center and not costcenter

2) field name on user table is employee_number and not employee

3) Also OOB there is no application field on user table. so is it a custom field then u_application

Here is the updated script

I assume your manager variable is reference type and not string

If it's string then use this

obj['manager_name'] = gr.getDisplayValue('manager');

var CheckRecords = Class.create();
CheckRecords.prototype = Object.extendsObject(AbstractAjaxProcessor, {

	checkRecordPresent: function(){

		var obj = {};
		var id = this.getParameter('sysparm_userID');           
		var gr = new GlideRecord('sys_user');
		gr.addQuery('sys_id', id);
		gr.query();
		if(gr.next()){
			obj['email'] = gr.getValue('email');
			obj['employee_id'] = gr.getValue('employee_number');
			obj['manager_name'] = gr.getValue('manager');
			obj['title'] = gr.getValue('title');
			obj['cost_center'] = gr.getValue('cost_center');
			obj['application'] =gr.getValue('u_application');
		}
		return JSON.stringify(obj);
	},

	type: 'CheckRecords'

});

Client Script:

function onChange(control, oldValue, newValue, isLoading) {
	if (isLoading || newValue == '') {
		return;
	}

	if(oldValue != newValue){
		var ga = new GlideAjax('CheckRecords');
		ga.addParam('sysparm_name', "checkRecordPresent");
		ga.addParam('sysparm_userID', g_form.getValue('requested_for'));
		ga.getXMLAnswer(function(answer){
			var parser = JSON.parse(answer);
			g_form.setValue('email', parser.email);
			g_form.setValue('employee_id', parser.employee);
			g_form.setValue('manager_name', parser.manager);
			g_form.setValue('title', parser.title);
			g_form.setValue('cost_center', parser.costcenter);
			g_form.setValue('application', parser.application);
		});
	}
}

Regards
Ankur

[surya65]

Hi ankur,

when i use  type is string field  then its working, if i take type is reference its not working, below are the fields:

email ---> reference.

manager---->reference.

title ------->reference.

empoyee id---> reference.