Need to provide inactive user access to itil users but don't want to impact on form reference fields

[sandeep srivas3]

Hi,

I have a requirement in which I need to provide 'itil' users access to inactive users but don't want the impact on forms such as incident/problem/change etc as well as on portals variable which are taking reference of user table.
As I know there is a query business rule on user table that is restricting this. But if I add condition as gs.hasRole('itil') then it would be visible to all of the places for itil. And to add reference qualifiers on each tables which are taking user table reference  are quite complex.

Please suggest shortest possible method, which will not impact much on instance.

Thanks

[sandeep srivas3]

Hi Anurag,

Thankyou for the reply. But when I tried to create a report on sys_user table with active is false condition and impersonated with 'ITIL' user, reports is not showing any records  to itil.

Thanks

[Anurag Tripathi]

ya it wont work.

Only other way i can think of is add reference qualifiers to all fields that are reference to user table and deactivate the queryBR. But i wouldn't recommend it as it will be a huge technical debt.

[Anurag Tripathi · Accepted solution]

You want this open for all ITIL or  members form some group ?

Im assuming the latter.

If that is the case then you can add that as a condition on query BR to bypass it for these selected users only.

[sandeep srivas3]

Thankyou @Anurag Tripathi . It would work at an extent.