Get MRVS values with RITM Number

Nirmala5
Mega Contributor

Hi All,

Need your help in querying MRVS variable sets value with RITM Number.

To get the parent variables values of a Catalog Item , we can query sc_item_option_mtom table.

How to get the values of the MRVS of the same catalog Item .

Kindly share your suggestions and script to glide record the MRVS values with RITM number.

Thanks in Advance.

1 ACCEPTED SOLUTION

DrewW
Mega Sage
Mega Sage

If you run a script to query the sc_req_item table and filter it for your catalog item you can use

var mrvData = "" + gr.variables.<MRVNAME>;

to get the JSON.

 

View solution in original post

2 REPLIES 2

Jace Benson
Mega Sage

These MRVS's answers are in a table `sc_multi_row_question_answer`.  

DrewW
Mega Sage
Mega Sage

If you run a script to query the sc_req_item table and filter it for your catalog item you can use

var mrvData = "" + gr.variables.<MRVNAME>;

to get the JSON.