- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2022 12:18 PM
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.
Solved! Go to Solution.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2022 12:44 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2022 12:22 PM
These MRVS's answers are in a table `sc_multi_row_question_answer`.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2022 12:44 PM
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.