show inactive users records in catalog

[Harish27]

Hi,

I have a field Requested on Behalf on a catalog item which is a reference field to the sys_user table. By default, we will be able to see only active users in the Requested field, But I also want to see inactive users in the requested field.

1. One solution for this is to give the user_admin role to a particular user(not the best solution though) and we are not allowed to modify the OOTB business rule as well.

I heard that some business rule is locking the user session to only show active records.. Don't know much abt that.

So how we achieve this? Any help would be massively appreciated..

Thanks!!

[Harish27]

Hi Ankur,

Just now I have checked in the native view and its not working.

Thanks!

[Ankur Bawiskar]

Hi Harish,

the above code shared works in native view for me

Regards
Ankur

[Ankur Bawiskar]

Hi Harish,

you can bypass the query

sharing 1 link which has similar requirement to yours

https://community.servicenow.com/community?id=community_question&sys_id=e62347e1dbd8dbc01dcaf3231f96...

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

Regards
Ankur

[Harish27 · Accepted solution]

Thank you ankur and jaspal. I have written and article on this https://community.servicenow.com/community?id=community_article&sys_id=e2f2878bdbd4ec1011762183ca961... . This solves my requirement.