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

VigneshMC · ‎09-25-2018

Try

while (req.next()) { 

req.variables.<variable_name>;

}

Rajesh73 · ‎09-25-2018

Because req.variables is empty, req.variables.<variable_name> is also empty.

johansec · ‎09-25-2018

var req = new GlideRecord('sc_req_item');
req.addQuery('sys_id','xxxxxxxxxxxxx');
req.query();
while (req.next()) {
 gs.print(req.variable_pool);
}

Rajesh73 · ‎09-25-2018

req.variable_pool is undefined.