Is there a way to filter user accounts active = false from ALL user fields?

[jlaps]

Good morning team,

We have multiple domains that sync into our SN instance, and IT people in particular end up with 2-8 valid AD accounts. On the SN side, we typically mark the domain admin (and all non-primary accounts) inactive so they get filtered from those fields that are setup to filter inactive.

The problem we are seeing is that the user fields are EVERYWHERE, and not all of them have the inactive filter on them, so when a manager runs a report against a specific assignee, that person shows up 2-8 times, and it is not easy for a non-admin to be able to tell which MARK SMITH is the correct MARK SMITH.

Is there a way to filter inactive by default in all user fields without having to edit every field in every spot?

[Allen Andreas · Accepted solution]

Hello,

Out of box, there's a "user query" query business rule on the sys_user table to filter out inactive users from most everyone except admin and user_admin, I believe.

You'd want to review this and consider looking at this from global and the top domain.

This would apply the inactive filter to all user query requests to the database without the need to build individual filters of the same for every single time you're referencing the user table.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[jlaps]

Ooh, that is good. Checking it out!

[jlaps]

This did not work system wide like hoped, but it did resolve a lingering account matching issue, so this was a win. This was reactivated (was inactive since 2014) and so far has been positive.

Thanks!

[Allen Andreas]

Hello,

before query business rules apply system wide when that table is involved in a query to the database (unless scripts are using setWorkflow(false)...causing the BR to not run).

Thanks!