The CreatorCon Call for Content is officially open! Get started here.

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

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

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.