How to export the variables of specific RITMs in XML?

[Suggy]

We have around 3000 RITMs but I need to move only 500 RITMs from one SN to another SN instance (including the variables and its values for 500 RITMs)

I used a filter to export those 500 RITM via XML and imported in target instance but the variables section did not show up on the RITM, and I understand the reason - that the variable data sits in different table which is sc_item_option.

Hence, I went to sc_item_option table to export the XMLs but problem is that, I couldnt find a way to use the filter on this table.. something like 'RITM is one of <1,2,3..500>' on this table.

Anyone knows how to export the variables and its values from sc_item_option table for those specific 500 RITMs?

[Chaitanya ILCR]

Hi @Suggy ,

move sc_req_item, sc_item_option and sc_item_option_mtom

records

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[J Siva]

Hi @Suggy 
Use "sc_item_option_mtom" many-to-many table.
Regards,
Siva

[Shraddha Kadam]

Hello @Suggy ,

You need to import the XML from below tables

sc_item_option_mtom

sc_item_option

[GlideFather]

Hi @Suggy 

You need to export Variables and the corresponding chocies:

• Variables
  • item_option_new
  • example: "Disk"
• Variable sets
  • item_option_new_set
• Variable's and Variable Set's choices
  • question_choice
  • example: ", 128 GB, 256 GB, 512 GB, etc"
  • it covers both select box and multiple choice
•  

And I hope I haven't forgotten anything.