Ability to see all users in the sys_user reference field irrespective of the domains

[balakumar1]

Hi,

As per the default implementation, users in domain A can't see users in domain B if B is above A in hierarchy, or B is not in the hierarchy of A at all.

We would like users in domain A to see users in domain B in a sys_user reference field.

Is that possible? I feel that this could be a generic requirement across all users of ServiceNow. Wondering if there is already a solution for this.

Maintaining a second sys_user table is an option. But that seems to me like a complex option because the sys_id in the sys_user and sys_user1 table should remain same because in lot of scripts, many parts depend on sys_id. For eg. if(current.assigned_to == gs.getUserID()) {.... }

This will fail if the new sys_user1 table has a different sys_id for the user.

Any help please.

Regards,

Bala

[balakumar1]

Hi Michael,

I am not sure how this code works for you. I must say you are lucky. It throws all sorts of exception if I use this code. I tweaked the code in different ways and nothing seems to work.

Anyway, thank you so much for your time and help. I'll continue looking for some other ways to solve this issue.

[alexander_kubra · Accepted solution]

Hi Bala,

I'd suggest adding the global_visibility=true attribute to the sys_user table - it will simply disable domain separation for that table. Basically it will allow you to keep the table sort of domain separated (as the sys_domain column still remains there) but you'll have to write your own ACLs or query Business Rules in order to get the needed "level of separation".

Hope it helps.

Alexander