question Re: Is it possible to copy multi-row variable data to another record? in Developer forum

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

nyancer3 — Fri, 14 Jun 2019 19:09:50 GMT

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?

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

Mark Roethof — Fri, 14 Jun 2019 19:58:59 GMT

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

---

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

nyancer3 — Fri, 14 Jun 2019 20:08:44 GMT

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 🙂

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

Hristo Ivanov — Wed, 27 Nov 2019 13:00:15 GMT

Hello,

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

Thank you in advance!