How do you filter users that are not in a specific team? | Community
Skip to main content
J
JoshTe1
March 22, 2022
Question

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

  • March 22, 2022
  • 1 reply
  • 533 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

NicholeVargas
Adobe Employee
NicholeVargasAdobe Employee
Adobe Employee
April 6, 2022

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!

Terms & ConditionsAccessibility statement

Loading footer...