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

n_kishore
Giga Contributor

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

1 ACCEPTED SOLUTION

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


View solution in original post

10 REPLIES 10

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Nanda,



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


GlideAjax - ServiceNow Wiki


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


Abhinay Erra
Giga Sage

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


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