Copying records with variables from one instance to another instance

Cesar Arakaki
Tera Expert

I'm trying to migrate records generated by record producer from a custom table of one instance to another instance, however, the variables are not being copied correctly from the question_answer table. Is there any other way?

 

1 - Source record:

CesarArakaki_0-1727894845917.png

 

2 - Target record:

CesarArakaki_1-1727895241811.png

Note that in the destination record the values ​​are correct, but it did not take into account the record producer's UI Policies rules, as if it had lost the reference.

 

 

1 ACCEPTED SOLUTION

I would like to share here the solution I found that helped me solve my problem. Basically, I needed to copy the records from the sc_item_produced_record table, which is a table that stores the record's reference to the record producer.

 

Reference post:

Copy variables from one record to another - ServiceNow Community

View solution in original post

3 REPLIES 3

Brad Bowman
Kilo Patron
Kilo Patron

If the values are correct, the copy worked correctly.  Are you referring to a UI Policy to make the variables read only? Do the policies exist on the table in the target instance? You can do this with a Client Script on the the table in whatever instance

function onLoad() {
   g_form.setVariablesReadOnly(true); 
}

Hi Brad. Thanks for the quick response. The entire application scope was migrated from the source instance. My biggest problem is in the portal, which is where the user accesses the data. See the examples:

 

1 - Source Portal:

CesarArakaki_0-1727902974517.png

 

2 - Target Portal:

CesarArakaki_1-1727903001643.png

The values ​​are in the registry, but I believe that the copy caused the variables to lose the record producer reference and the Portal cannot render the values.

I would like to share here the solution I found that helped me solve my problem. Basically, I needed to copy the records from the sc_item_produced_record table, which is a table that stores the record's reference to the record producer.

 

Reference post:

Copy variables from one record to another - ServiceNow Community