My Lists from legacy workspace

[Dennis Ford]

We have been on legacy workspaces for about a year and a half, so our users have created quite a few "My Lists" in the legacy workspace. It appears that these will not be available (migrate) into configurable workspaces and every user will have to manually recreate each "My List" they have configured.  Is that correct?  Is it possible to write a script to recreate them all?  Thanks!  

[ThunderDev]

Hey Zrebak, 

I am dealing with the same issue. I need to move the users list (sys_aw_my_list) from Agent Workspace to Configurable Workspace (sys_ux_my_list) but I cannot access the sys_ux_my_list table since it is in a private scope. Can you give more details on the work around you came up with please?

[zrebak]

Hi, sorry for late reply.

This is the script that worked:

var total = 0;
var bms = new GlideRecord("sys_ui_bookmark");
bms.addQuery("url", "CONTAINS", "_list.do?");
bms.addNotNullQuery("user");
bms.query();
while (bms.next()) {
temp = {};
temp.title = bms.title;
var user = new GlideRecord("sys_user");
user.get(bms.user);
temp.username = user.user_name;
var regex = /^\/?(.*)_list\.do.*_query=(.*)/;
var match = bms.url.toString().match(regex);
var test = regex.test(bms.url.toString());
if(match != null && test) {
var tableName = match[1];
var query = match[2];
temp.order = bms.order;
var inject = new GlideRecord("sys_aw_my_list");
inject.initialize();
inject.setWorkflow(false);
inject.autoSysFields(false);
inject.title = temp.title;
inject.table = tableName;
inject.condition = query != null ? query : '';
inject.order = temp.order;
inject.sys_created_by = temp.username;
inject.sys_created_on = new GlideDateTime();
inject.sys_updated_by = temp.username;
inject.sys_updated_on = new GlideDateTime();
inject.update();
total++;
}
}
gs.info("AW lists injected: " + total);

Create a Fix script out of it, export out the XML, change the scope from global to the private scope, reimport and execute.