We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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
Giga 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.