Is it possible to copy multi-row variable data to another record?

[nyancer3]

We are currently working on building out a service catalog and we have a few items that will spawn a Requested Item that requires an approval. After that, instead of creating a Catalog Task we are creating a Change Request.

I have some code that will copy the variables from the Requested Item to the Change Request, but I just noticed that it is not copying over the multi-row variable set information. When I look at the table sc_item_option_mtom, I can see entries for the variables that are included in the multi-row set, but they are empty. I cannot seem to find where the multi-row variable data are stored.

Has anyone come across this before? Is there an easy way to copy this data, or make it easily visible on the Change Request?

[Mark Roethof · Accepted solution]

Hi there,

Have a look at the Multi Row Question Answer table [sc_multi_row_question_answer]. The variables from the Multi Row Variable Set are stored within there.

This is for both Catalog Items and Record Producers. Where Catalog Items also use a mtom table, the multi row variables doesn't.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn

[nyancer3]

Perfect, thank you Mark! And here I thought they might have named it similar to the existing ones!

Should be super easy to copy from there 🙂

[Hristo Ivanov]

Hello,

Were you able to copy the MRVs? If yes, could you please explain how? 

Thank you in advance!