Queries on Agile 1.0 to 2.0 Migration

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.

Any version

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.