- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-02-2024 11:57 AM
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:
2 - Target record:
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.
Solved! Go to Solution.
- 719 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 05:47 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-02-2024 12:20 PM
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);
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-02-2024 02:06 PM
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:
2 - Target Portal:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 05:47 AM
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