New record menu items migration from ITSM Agent Workspace to Service Operations Workspace for ITSM
Migration of the new record menu items from ITSM Agent Workspace to Service Operations Workspace for ITSM includes identifying the required tables, identifying new record menu items for migrations, and the migration process.
System property
sys_property: sn_sow_migration.itsm_aw_migration_tables
Records corresponding to only these tables are migrated from ITSM Agent Workspace to Service Operations Workspace.
Table used for migration
New Record Menu Item [sys_aw_new_menu_item]: Contains the active records to migrate from ITSM Agent Workspace to Service Operations Workspace for ITSM.
How the migration utility identifies new record menu items for migration
- Active records of ITSM Agent Workspace table specified by the New Record Menu Item [sys_aw_new_menu_item] table.
- The records of a table already mentioned in the new record menu item configuration for Service Operations Workspace aren’t migrated to avoid duplicates.
The utility migrates only a copy of an active record if duplicate active records are specified in the New Record Menu Item [sys_aw_new_menu_item] table.
How the migration works
The Service Operations Workspace migration utility uses the following sequence to migrate new record menu items from ITSM Agent Workspace to Service Operations Workspace for ITSM. All these actions are done by the utility.
- Searches for the current new record menu item configuration for Service Operations Workspace.
Queries the UX Page Property [sys_ux_page_property] table for the following:
- Service Operations Workspace page (aa881cad73c4301045216238edf6a716 is the sysId for Service Operations Workspace page record).
- chrome_tab (Name for UX page property record that stores a new record menu item for Service Operations Workspace)
- Uses the record obtained from Step 1 to search for tables that are already part of the new record menu item for Service Operations Workspace.
- Ignores the existing tables during migration to avoid duplicates.
- Searches the records of the New Record Menu Item [sys_aw_new_menu_item] table whose field values are set as follows:
- active is true
- workspace is Agent Workspace
- table is one of sn_sow_migration.itsm_aw_migration_tables.
For each record, if the table name isn’t a part of existing tables and if the same table name isn’t processed earlier, then the migration utility creates a JSON object.
- Creates a JSON object that contains data corresponding to each record as follows:
{ "label": { "translatable": true, "message": "New " + tableLabel }, "routeInfo": { "route": "record", "fields": { "table": table, "sysId": "-1" }, "multiInstField": "sysId" }, "condition": { "tableDescription": { "table": table, "canCreate": true } } }; - Adds the code to the existing chrome_tab JSON value for the new record menu.