question Re: Populate a reference variable on a catalog item - catalog client script in ITOM forum

Populate a reference variable on a catalog item - catalog client script

Nate23 — Mon, 14 Jul 2014 19:29:35 GMT

Hello all,

I have tried a number of things, but can't seem to populate this reference field. Here is the scenario:

This Catalog Item has a reference variable to pull current user from the sys_user table. I have another reference field on the catalog item to the cmn_location. This is also a reference field in the sys_user table. The client wants their location to auto populate. I tried dot walking, and querying, but can't seem to get the reference field to populate. when I try to display this is an alert I get [Object] [Object].

I've went through my stages of different code, but for visual purposes here is the onLoad client script:

	var gr = new GlideRecord('sys_user');
	gr.addQuery('user_name', g_form.getValue('customer_info_requestor'));

	gr.query();

while(gr.next()){

g_form.setValue('visitor_access_which_post', gr.location);

}

Any Ideas?

Re: Populate a reference variable on a catalog item - catalog client script

ohhgr — Mon, 14 Jul 2014 19:38:35 GMT

Hi Nathan,

Could you try using "variables" prior to variable name? Check if that does any difference in the outcome

Thanks,
Mandar

Re: Populate a reference variable on a catalog item - catalog client script

Nate23 — Mon, 14 Jul 2014 19:44:39 GMT

Hey Mandar,

This is a catalog client script, not a client script, so if you mean using variables.variable_Name this does not work either. It's driving me crazy.

Thanks,

Nathan

Re: Populate a reference variable on a catalog item - catalog client script

Nate23 — Mon, 14 Jul 2014 20:17:10 GMT

Found the solution, just took a lot of testing and . Thanks for y'alls help!

In case someone else runs into this problem here was the solution:

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

if (newValue == '') {

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

return;

}

if (!g_form.getControl('visitor_access_which_post'))

return;

var caller = g_form.getReference('customer_info_requestor', setLocation);

}

function setLocation(caller) {

if (caller)

g_form.setValue('visitor_access_which_post', caller.location);

}