Value on new field in the update set are not retrieved on other instance

[kannann_]

Hi All,

We have added a new field on sys_update_set table which will hold the value of the Change ID under which this update set is implemented.

When we Retrieve update sets on another instance it does not gives us the value on the Change ID field. I checked the UI Action "Retrieve Completed Update Sets" but was not able to find anything.

Please help me out on this.

Thanks,

Kannan

[matthew_magee1 · Accepted solution]

Hi Kannan,

A few steps I had to do:

1. In DEV instance, create 'Application Version' on sys_update_set table
2. in DEV instance, create 'Application Version' on sys_remote_update_set table (make sure the dictionary is the exact as #1)
3. In DEV instance, update UI Action 'Export to XML', add line> retrievedUpdateSet.u_application_version = current.u_application_version;
4. In TEST instance (or any target instance), create 'Application Version' on sys_remote_update_set table

If I want to merge update sets in TEST, or any target instance, I filter on Remote Sys id>Application Version

Works like a champ

Matthew

[K_Tom]

Hello Matthew,

I'm facing a similar issue, I'm trying to follow your steps, but I stacked on the first one.

Could you please tell me how to : "create 'Application Version' on sys_update_set table"?

[OliverDoesereck]

Hi Kannan, 

I know this is a pretty old topic, but we had the same issues and requirements. 6 years later, it still isnt possible and custom fields on the sys_update_set and sys_remote_update_set Tables dont get transferred when using "Retrieve Completed Update Sets". The OOB Script Includes get encapsulated into the GlideUpdateSetWorker Class, which cannot be opened or customized.

So here is my method to synchronize custom fields between instances:

What: Business Rule
Table: Retrieved Update Set (sys_remote_update_set)
When: Before - Insert

try {
	if (!gs.nil(current.update_source)) {
		var Encrypter = new GlideEncrypter();

		// Open Channel to Update Source Instance
		var r = new GlideRemoteGlideRecord(String(current.update_source.url), 'sys_update_set');
		r.setBasicAuth(String(current.update_source.username), Encrypter.decrypt(current.update_source.password));
		r.addQuery('sys_id', current.remote_sys_id);
		r.query();
		if (r.next()) {
			current.setValue("<YOUR CUSTOM FIELD>", r.getValue("<YOUR CUSTOM FIELD>"));
		}
	}
} catch (err) {
	// YOUR Catch Logging
}

You only need to replace the 2 "<YOUR CUSTOM FIELD>" with your own fields.

Kind regards,
Oliver