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?

[GlideFather]

@Suggy it didn't enter everything:

• sc_cat_item
• sc_cat_item
• item_option_new_set
• sc_item_option_mtom v
• sys_ui_policy
• sys_ui_policy_action
• categories and user criteria!

[GlideFather]

@Suggy don't you maybe have a chance to move it by cloning? if it is from dev to test, it would be maybe easier and preventing losing data.

If it is also big amount of data you can ask ServiceNow in HI Case for assistance.

[Suggy]

@GlideFather  @Shraddha Kadam @J Siva @Chaitanya ILCR  I am so sorry for not being clear. I have updated my question properly now. If you know the answer, please do let me know. thanks in advance 🙂

[Shraddha Kadam]

Hello @Suggy ,

I believe you want the variable values as well for the related RITMs. Hence also you need to migrate the xmls of the below two table which I earlier mentioned-

sc_item_option_mtom.LIST

sc_item_option.LIST

Fo through this table you will get the better idea

[Suggy]

@Shraddha Kadam but how to use the filter for those 500 RITMs on sc_item_option.LIST table?