Hi Allen,
Sorry for the late update, had to place that task on hold while I completed some other work.
Since something's blocking workflows and I couldn't figure out the cause I resorted to running the business rule on insert of a user into sys_user_grmember, so the script will run unnecessarily for 90% of insertions/deletions but we do it infrequently enough that I'm not concerned with any performance issues. Below is the code that I've created, for some reason the personalisations I create for facilities_request_task work but the one that I create for facilities_request table doesn't work, the record exists in sys_ui_list however the user does not have the personalisations when I load the list.
(function executeRule(current, previous /*null when async*/) {
//running BR on sys_user_grmember due to unknown function calling
//setworkflow(false) on addition of inherited roles to sys_user_has_role
//after a projects role is added/removed, re-adjust list view layout
var unitedView = 'db567f14db664450801791f38a961945';
var checkRole = new GlideRecord('sys_user_has_role');
checkRole.addQuery('user', current.user);
checkRole.addQuery('role.name', 'ENDSWITH', 'projects');
checkRole.query();
if(checkRole.next()){
var ft = new GlideRecord('sys_ui_list');
ft.addQuery('name','facilities_request_task');
ft.addQuery('sys_user', current.user);
ft.query();
if(!ft.next()){
gs.addInfoMessage('Customising Form layout for Facilities Requests and Tasks');
var ft_id = [];
ft.initialize();
ft.name = 'facilities_request_task';
ft.view = 'Default view';
ft.sys_user = current.user;
ft_id.push(ft.insert());
ft.initialize();
ft.name = 'facilities_request_task';
ft.view = unitedView;
ft.sys_user = current.user;
ft.parent = 'facilities_request';
ft_id.push(ft.insert());
//gs.info('--AE-- new FCRT created for ' + current.user.name + ', IDs: ' + ft_id)
var elements = ['number', 'facilities_request.u_client','facilities_request.u_type_of_request', 'short_description', 'state', 'priority', 'due_date'];
for(var id = 0; id < ft_id.length; id++){
for(var ele = 0; ele < elements.length; ele++){
var fte = new GlideRecord('sys_ui_list_element');
fte.initialize();
fte.element = elements[ele];
fte.position = ele;
fte.list_id = ft_id[id];
fte.insert();
//gs.log('--AE-- created list elemen')
}
}
}
var fr = new GlideRecord('sys_ui_list');
fr.addQuery('name','facilities_request');
fr.addQuery('sys_user', current.user);
fr.query();
if(!fr.next()){
fr.initialize();
fr.name = 'facilities_request';
fr.view = 'Default view';
fr.sys_user = current.user;
var fr_id = fr.insert();
//gs.info('--AE-- creating FR view for ' + current.user.name)
var frelements = ['number', 'location', 'u_client', 'u_type_of_request', 'state', 'u_reported_on'];
for(var frele = 0; frele < frelements.length; frele++){
var fre = new GlideRecord('sys_ui_list_element');
fre.initialize();
fre.element = frelements[frele];
fre.position = frele;
fre.list_id = fr_id;
fre.insert();
}
}
} else {
gs.addInfoMessage('Removing Form layout customisation for Facilities Requests and Tasks');
var dft = new GlideRecord('sys_ui_list');
dft.addQuery('sys_created_by', '!=',current.user.user_name);//don't remove customisation if user has modified it
dft.addQuery('name','facilities_request_task');
dft.addOrCondition('name','facilities_request');
dft.addQuery('sys_user', current.user);
dft.query();
while(dft.next()){
var dfte = new GlideRecord('sys_ui_list_element');
dfte.addQuery('list_id', dft.getUniqueValue());
dfte.query();
dfte.deleteMultiple();
dft.deleteRecord();
}
}
})(current, previous);
I've checked the XML between the personalisation created by my script and by the user, and the only difference is the following properties, but I am unable to clear them, they get automatically set.
