Notifications

10 views

Description

Unable to pull the information in the multi-row variable set via script 

Code Used: 

var mrvs;
var item = new GlideRecord('sc_req_item');
item.addEncodedQuery('sys_id=401e1acfdbc69c1051f8d8c75e96197c');
item.query();
if(item.next()){


mrvs = item.variables.vs_budget_line_item;
gs.print(mrvs);

}

Cause

The variable set name is being used instead of the internal name.

Resolution

In the script, the variable set name is provided as vs_budget_line_item which is the name of the variable set.

When trying to pull the information from the database we need to provide the internal name as the information is stored based on the internal name.

The internal name of the Budget line item variable set is u_vs_budget_line_item.

Changing the script with the internal name will fix the issue.


Article Information

Last Updated:2020-09-23 22:03:16
Published:2020-09-23