Variables is empty for GlideRecord query record.

Rajesh73 · ‎09-25-2018

Variables is empty for GlideRecord query record, even though it has variables.

	var req = new GlideRecord('sc_req_item');
	req.addQuery('sys_id','=','XXXXXXXXXXXXX');
	req.query();
while (req.next()) {
 // req.variables is empty
}

How to get the variables value ?

Rajesh73 · ‎09-26-2018

Figured out that the value of variables is empty on client script but works fine on business script.

Prateek's solution is partially working on client script but need to query two more additional tables sc_item_option and item_option_new to get variable value and name.

Thanks for all your help.

View solution in original post

johansec · ‎09-25-2018

That is wierd, I tested this. What kind of script are you running this in? Background script, fix script widget server script?

Are you sure the sysid is correct.

Harsh Vardhan · ‎09-25-2018

var req = new GlideRecord('sc_req_item');
req.get('sys_id','XXXXXXXXXXXXX');
gs.print(req.variables.<variable_name>);

Rajesh73 · ‎09-25-2018

The value is still empty.

Harsh Vardhan · ‎09-25-2018

can you share the screenshot? have you mentioned the correct sysid

Rajesh73 · ‎09-25-2018

Added the attachments to question.