Expand my Community achievements bar.

How do you filter users that are not in a specific team?

Avatar

Level 1

Hello community!

I'm creating an audit report of my users to ensure they are set up properly. One of the things I'm looking for is to ensure that everyone in a specific org is part of a team. I can filter by home team ID because that's a singular entity. But the teamIDs seems to be a string list based on what others have said so checking whether a specific id is "in" that "list" doesn't seem possible at a cursory glance. I thought about using EXISTS or NOTEXISTS but the User object doesn't have teamIDs available.

To reiterate using an example, given:

User A's teams: Team 1, Team 2, and Team 3

User B's teams: Team 2, Team 3

User C's team: Team 1, Team 3

I want a list of all users NOT in Team 1, so User B would be the only user on the report/filter returned.

Any thoughts on this?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Employee Advisor

Josh - it can be done through an EXISTS filter on a User Report. If you switch to text mode filters, paste the following and swap out ID HERE with the ID of the specific team you want to filter for, that should work.

This will pull in a list of all users missing from that specific team, regardless of whether or not it is listed as their Home Team or under Other Teams.

EXISTS:A:$$EXISTSMOD=NOTEXISTS

EXISTS:A:$$OBJCODE=TEAMMB

EXISTS:A:teamID=ID HERE

EXISTS:A:userID=FIELD:ID

If that isn't exactly what you were looking for, or have additional questions, let me know!