Where are Entries in Multi-Row Variable Sets Stored?

[jmiskey]

We have a Catalog Item that has a Multi-Row Variable Set.  We have a request that was submitted that we cannot do with, it says that there is a script error.  We can see the values on the RITM but cannot update the RITM at all because of the script error.  We found another request that is nearly identical, except for one minor thing.  One of the fields they populate is network path.  We think they entered an illegal character in it, and we want to fix it.  However, since we cannot update the RITM, we cannot fix it there.  I think we need to update it directly on the underlying table.  But we do not know the name of the table that would hold that entry. 

Does anyone know?

Thanks

[rlatorre]

They are stored as a JSON array and are accessible via scripting:

• Vendor Documentation
• Scriptable service catalog variables
• Useful Community Post

Example:

var mrvs;
var itemID = 'current.sys_id'; // sys_id of RITM
var ritmGR = new GlideRecord('sc_req_item');
if (ritmGR.get(itemID)) {
    mrvs = ritmGR.variables.testing_multi_row_01; // "testing_multi_row_01" is the 'Internal Name' of the MLVS
}
 
// Resulting value for mrvs
[ {
  "u_budget_line_id" : "BID01",
  "u_forcast_purch_date" : "2019-03-12",
  "u_forcast_pins_date" : "2019-03-13",
  "u_major_sub" : "36c36eb6db4d27447a549806b996195e",
  "u_amount_cap" : "5000"
}, {
  "u_budget_line_id" : "BID02",
  "u_forcast_purch_date" : "2019-03-18",
  "u_forcast_pins_date" : "2019-03-19",
  "u_major_sub" : "36c36eb6db4d27447a549806b996195e",
  "u_amount_cap" : "6000"
}, {
  "u_budget_line_id" : "BID03",
  "u_forcast_purch_date" : "2019-03-25",
  "u_forcast_pins_date" : "2019-03-26",
  "u_major_sub" : "36c36eb6db4d27447a549806b996195e",
  "u_amount_cap" : "7000"
} ]

// Get all the values in a single column
var budLines = mrvs.u_budget_line_id
// Resulting value for that column
[BID01, BID02, BID03]
 
// Get the number of rows in the MLVS
var rows = mrvs.getRowCount();
// Resulting value for number of rows in MLVS
3

[Sathish Goud]

Hi Mark,

How to get the key (attribute) information from above example? I trying to get the variable names

[u_budget_line_id,u_forcast_purch_date,u_forcast_pins_date,u_major_sub,u_amount_cap]

Thanks in advance!,

Sathish

[maria03]

The useful community post link  he added above has an example.

[Mark Roethof · Accepted solution]

Hi there,

Not sure if I'm understanding you're question right, but looking at the title:

Are you looking for the "Multi Row Question Answer" table? sc_multi_row_question_answer

Kind regards,
Mark