question How to Populate incident table based on Caller id using Script Include in Developer forum

How to Populate incident table based on Caller id using Script Include

shaik_irfan — Mon, 14 Aug 2017 15:27:08 GMT

When ever i select Caller id i need to populate email, phone, manager name, & title, this i need to get using Script include.

PLEASE HELP ME OUT on this

Re: How to Populate incident table based on Caller id using Script Include

Rohith Sabbinen — Mon, 14 Aug 2017 15:46:35 GMT

Hi Shaik,

Use an onChange catalog client script. It should work for your needs.

function onChange(control, oldValue, newValue, isLoading) {
var id = g_form.getValue('u_first_field');//replace 'u_first_field' with the name of your reference field.
var user = new GlideRecord('sys_user');
user.addQuery('sys_id',id);
user.query();
if ( user.next() ) {
g_form.setValue('u_manager_field', user.manager);
g_form.setValue('u_last_name', user.last_name);
g_form.setValue('u_whatever', user.field_on_sys_user);
}
}

Note: Modify the above Script accordingly.

Thank you.

Rohith.

Re: How to Populate incident table based on Caller id using Script Include

shaik_irfan — Mon, 14 Aug 2017 15:49:29 GMT

Rohith,

I already achived this via client scirpt since Glide Record is not a Best practice to use in Client script my manager asked me to implement same via Script include.

Can you please help me out ?

Re: How to Populate incident table based on Caller id using Script Include

Rohith Sabbinen — Mon, 14 Aug 2017 16:09:58 GMT

Hi,

For Auto population of the above defined Variables you can write an Script Include and call the same Script Include in an OnLoad Catalog Client Script as mentioned below:

Script Include:

var requestor_details = Class.create();

requestor_details.prototype = Object.extendsObject(AbstractAjaxProcessor, {

requestor_info: function() {

var result = this.newItem("result");

var logged_user = gs.getUserID();

var user_detail = new GlideRecord('sys_user');

user_detail.addQuery('sys_id',logged_user);

user_detail.query();

while(user_detail.next())

{

result.setAttribute("user",user_detail.sys_id);

result.setAttribute("phone", user_detail.phone);

result.setAttribute("email",user_detail.email);

result.setAttribute("location",user_detail.location);

}

type: 'requestor_details'

});

2) Then you can write an On Load Catalog Client Script wither on your Catalog Item or on the Variable Set to have the variables populated as shown below:

Script:

function onLoad()

{

var ga = new GlideAjax("requestor_details");

ga.addParam("sysparm_name","requestor_info");

ga.getXML(ajaxResponse);

function ajaxResponse(serverResponse) {

var result = serverResponse.responseXML.getElementsByTagName("result");

var phone = result[0].getAttribute("phone");

var user = result[0].getAttribute("user");

var email = result[0].getAttribute("email");

var loc = result[0].getAttribute("location");

g_form.setValue('requestor_phone',phone);

g_form.setValue('requestor_name',user);

g_form.setValue('Location_user',loc);

}

Replace your Variable Name appropriately in the Set Value Conditions say for example in place of the variable "Location_user" with your Location Variable.

In a Similar Way you can try for other Variables also.

Re: How to Populate incident table based on Caller id using Script Include

shaik_irfan — Mon, 14 Aug 2017 16:14:08 GMT

Thanks Rohith ,

Can i do this using onChange ?

Mine is Incident table

Re: How to Populate incident table based on Caller id using Script Include

Rohith Sabbinen — Mon, 14 Aug 2017 16:25:29 GMT

Yes you can do it, Just modify the On load as per your requirement.

I'm going to recommend against putting a bunch of related fields on the form as a bad practice. Most of this information is available simply by hovering over the "i" icon next to the reference field. Unless you anticipate the user changing their department, customer unit, or something else during the request process (which isn't likely for most of this information) then I would leave it off the form. It's what reference fields were designed to do.

Thanks,

Rohith.

Re: How to Populate incident table based on Caller id using Script Include

shaik_irfan — Mon, 14 Aug 2017 16:57:04 GMT

Rohith,

Everything is working fine only i have 2 doubts,

Under Location i can see Sys_id instead of display value, can you please let me know how to convert it into Displlay Value

Other is Can you please explain me below script in details what does Set Attribute does ? what is Resulg [0]

result.setAttribute("user",user_detail.sys_id);