question Re: Getting value of reference field from user table in Catalog Client Script in ServiceNow AI Platform forum

Getting value of reference field from user table in Catalog Client Script

n_kishore — Mon, 01 Aug 2016 17:14:40 GMT

I am having a requirement where i have to get the field values and show it in Catalog item when the requestingfor field is changed.
I wrote a client script and querying the data from User table for the user in requestingfor field.
How ever there is a field in User table called Location which is a reference field. I need to read that in my following script.

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

var userRec = g_form.getReference('requestingfor', getTermedRec);

function getTermedRec(userRec){

if(!isLoading && newValue != oldValue){

g_form.setValue('req_', userRec.title);

g_form.setValue('requester_email', userRec.mobile);

* i need to get the value of location which is a reference field in User table. Where as above two fields were single line text field.
I cannot do g_form.setValue('requester_location', userRec.location); its not working.

}

Can anyone please help me get the script to read the display value, Let me know if you need additional info to assist.

Thanks,
Nanda

Re: Getting value of reference field from user table in Catalog Client Script

Pradeep Sharma — Mon, 01 Aug 2016 17:16:40 GMT

Hi Nanda,

The best option will be do GlideAjax and then set those values at client side. more info here.

GlideAjax - ServiceNow Wiki

Re: Getting value of reference field from user table in Catalog Client Script

Abhinay Erra — Mon, 01 Aug 2016 17:18:57 GMT

Is your 'requester_location" a reference field to cmn_location table?

Re: Getting value of reference field from user table in Catalog Client Script

n_kishore — Mon, 01 Aug 2016 17:20:40 GMT

requester location is a single line text field.
I want to populate this with the "requestingfor" location. This is dependent on requestingfor.

Re: Getting value of reference field from user table in Catalog Client Script

Abhinay Erra — Mon, 01 Aug 2016 17:24:37 GMT

Ahh.. Then you cannot use getReference() in your use case. getReference() will only work for one level dot walking. You cannot dot walk into the location table and get name here. So, your only option is to use GlideAjax. Let me know if you need help in scripting?

Re: Getting value of reference field from user table in Catalog Client Script

Pradeep Sharma — Mon, 01 Aug 2016 17:28:18 GMT

Use this thread for reference and let me know if you are blocked.

Return multiple values from Glide Ajax

Split an Array from GlideAjax on the Client Side

Re: Getting value of reference field from user table in Catalog Client Script

Kalaiarasan Pus — Mon, 01 Aug 2016 17:34:02 GMT

I believe you should be changing the location to reference type instead of string. This will give the user option to view related details too if needed else he/she may just can see the display value itself.

This will also make it easier for you to set the location value with just a getreference instead of doing a Glideajax for the same.

Re: Getting value of reference field from user table in Catalog Client Script

n_kishore — Mon, 01 Aug 2016 17:36:16 GMT

Hi Kalai,

I will change this to reference field.
Can you use my above script and add the lines which i need to get the value of location.

Thanks.

Re: Getting value of reference field from user table in Catalog Client Script

Abhinay Erra — Mon, 01 Aug 2016 17:38:33 GMT

Your current script should work, if you change it to reference type.

Re: Getting value of reference field from user table in Catalog Client Script

Kalaiarasan Pus — Mon, 01 Aug 2016 17:45:22 GMT

Try

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

if(newValue=='')

{

g_form.setValue('req_', '');

g_form.setValue('requester_email', '');

g_form.setValue('requester_location', '');

}

if(!isLoading && newValue != oldValue){

var userRec = g_form.getReference('requestingfor', getTermedRec);

}

function getTermedRec(userRec){

g_form.setValue('req_', userRec.title);

g_form.setValue('requester_email', userRec.mobile);

g_form.setValue('requester_location', userRec.location);

}

Re: Getting value of reference field from user table in Catalog Client Script

johnram — Fri, 22 Sep 2017 18:48:24 GMT

The ServiceNow Wiki content is no longer supported. Updated information about this topic is located here: AJAX

Visit http://docs.servicenow.com for the latest product documentation