Catalog Client Script : Doing a query with a sys_id and setting catalog variables to record values

[Mike S3]

On load , I am able to get the sys_id that was passed through the URL and I've set this value to a field called project. 

I would like to query the u_earb table to find the record that matches that sys_id . Then populate variables on the catalog based on that record . 

I have a rough script , but it doesn't appear to be working . 

function onLoad() {
 
  var project=	g_form.getValue('project');
	
	var gr = new GlideRecord('u_earb');


gr.addQuery('sys_id',project); 


gr.query();        
 g_form.setValue('u_earb_request_type',gr.u_earb_request_type);

	
}

[Ankur Bawiskar]

Hi,

use GlideRecord with callback

function onLoad() {

	var project = g_form.getValue('project');
	var gr = new GlideRecord('u_earb');
	gr.addQuery('sys_id',project); 
	gr.query(callBackMethod);
	function callBackMethod(gr){
		g_form.setValue('u_earb_request_type',gr.u_earb_request_type);
	}

}

Regards
Ankur

[Mike S3]

Thanks Ankur , but it looks like its returning an undefined value . I added an alert for gr.u_earb_request_type to see what value was being populated. 

[Ankur Bawiskar]

Hi,

are you using correct field to fetch the data from your table?

Regards
Ankur

[Mike S3]

The sys_id in the project field , does match an actual record in the u_earb table . 

u_earb_request_type is also a valid field in the u_earb table :