HR Agent workspace HR Cases - My List not showing

[Dharma Liyanage]

Hi There;

Workspace for HR Agents The My List was always visible in the HR Case List View, but AD altered the user_id to ALL-CAPS, such as David.Smith now appears as DAVID.SMITH; the sys_id in the sys_user table is the same; the record is identical, but the user no longer has any lists under My List.

My question is why My List does not appear even though it has the same name when I check the My List table: sys_ux_my_list, which was created by = David.Smith. In UIB, where does comparison take place?

I appreciate any assistance in advance.

[pavani_paluri · Accepted solution]

HI @Dharma Liyanage ,

You can update the created by with exact user name after AD has changed it in the table  sys_ux_my_list.created_by because it might be case sensitive.

var gr = new GlideRecord('sys_ux_my_list');
gr.addQuery('created_by', 'David.Smith'); // old casing
gr.query();
while (gr.next()) {
gr.created_by = 'DAVID.SMITH'; // new casing from sys_user.user_name
gr.update();
}

Here is a code you can try for single user. If that works, you can use the same for all records.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[pavani_paluri · Accepted solution]

HI @Dharma Liyanage ,

You can update the created by with exact user name after AD has changed it in the table  sys_ux_my_list.created_by because it might be case sensitive.

var gr = new GlideRecord('sys_ux_my_list');
gr.addQuery('created_by', 'David.Smith'); // old casing
gr.query();
while (gr.next()) {
gr.created_by = 'DAVID.SMITH'; // new casing from sys_user.user_name
gr.update();
}

Here is a code you can try for single user. If that works, you can use the same for all records.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[pavani_paluri · Accepted solution]

Hi @Dharma Liyanage ,

If this solves your problem, Could you Please accept the solution.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P