Notifications

3 views

Description

During the Agile 1.0 to 2.0 migration, as part of the "Delete Customizations" step the customer has the below queries,

->Upon adding the property "com.snc.sdlc.scrum.pp.delete_customer_updates", the property got vanishes from the sys_properties table

->Deleting the entries from the sys_update_xml table means the customizations are rolledback and ready for the upgrade.

 

Release or Environment

Any version

Resolution

Query1:

Whether the property "com.snc.sdlc.scrum.pp.delete_customer_updates" gets deleted after creating the same as a part of the "Delete the customizations" step.

Response:

Business rule "deleteCustomerUpdatesForScrumApplication" will actually delete the property once it do it's job of deleting the entries from the sys_update_xml table,

var property = "com.snc.sdlc.scrum.pp.delete_customer_updates";
var properties = new GlideRecord("sys_properties");
properties.addQuery("name", property);
properties.query();
if (properties.next()){
properties.deleteRecord();
gs.log("[ScrumPP] Deleted system property " + property);
}

Query2:

If deleting the records from the sys_update_xml is considered to be rolling back the customizations.

Response:

The BR has the below call on the sys_update_xml table,

var records = new GlideRecord("sys_update_xml");
records.addQuery("name", recordsToDelete);
records.query();
var count = 0;
while (records.next()) {
gs.log("[ScrumPP] Deleting " + records.name + " from update set " + records.update_set.name);
records.deleteRecord();
count++;
}

 

function getRecordsToDelete() {
var recordsToDelete = [
"sys_ui_list_control_3f85b6907f00000135a05e41c7547354",
"sys_ui_list_control_3f8607b47f0000012aaff213c654be45",
"sys_ui_list_control_6daa4a777f000001007607d32a0b44f0",
"sys_ui_list_control_7d3d1f917f000001798fc58141419300",
"sys_ui_list_control_aa8a1aae7f000001432d0e1142a85c2d",
"sys_ui_list_control_aa8a4bbe7f00000139552678204587f7",
``
``
``
``
"sys_script_8cd24091ef52200099620fa3f8225619",
"sys_script_9f298c85efa1200099620fa3f82256ba"
];

return recordsToDelete;



Based on the above logic, it will try to match the entries defined in the "getRecordsToDelete" function on the sys_update_xml table and it will delete those entries correspondingly.

Upon the records being deleted from the sys_update_xml, when we proceed with installing the "Install Agile Development 2.0." plugin, it will ensure to update the metadata to the latest code.

Article Information

Last Updated:2019-12-03 21:11:01
Published:2019-12-04