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

nyancer3
Tera Expert

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
Tera Patron

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

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

View solution in original post

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
Kilo Sage

Hello,

 

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

Thank you in advance!