Reference Qualifier Not Returning Inactive Users in Catalog Variable

[tilekarnilesh]

Hi Community,

I’m facing an issue where a catalog variable (Reference → sys_user) is supposed to show inactive users only, but even with an reference qualifier.

There is an ACL on sys_user.locked_out set to snc_internal, and the locked_out field becomes true after the user profile is set to Active = false. 

How can this issue be fixed, or is there any way to bypass it?

Thanks in advance

[Sandeep Rajput]

@tilekarnilesh Why are you checking the locked_out= False in this case. Simply apply Active = False condition in the reference qualifier to get the inactive users.

[tilekarnilesh]

@Sandeep Rajput Because I already checked with this filter and it’s not working.

[jonsan09 · Accepted solution]

You might have to take a look at the 'user query' business rule on 'sys_user' this BR prevents inactive accounts appearing for non-admin users. 

[tilekarnilesh]

@jonsan09  Why do we need to modify this Business Rule? Are you suggesting we deactivate it to allow inactive users to appear?