How to find all users who do not belong to a specific group? | Community
Skip to main content
Level 10
April 6, 2022
Solved

How to find all users who do not belong to a specific group?

  • April 6, 2022
  • 2 replies
  • 739 views

Hi

Is there a code for a report that someone can supply to find all active Users who don't belong to a specified group - whether it's their home group or other group? When I use "or" it doesn't work - because if they are in the Home Group and not Other Group it lists them.

Thanks!

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

Jill,

This is possible using an EXISTS filter within a User Report. You'll want to switch to text mode and replace ID HERE with the ID of the specific group. This will pull in a list of all active users who do not have that group listed as either their Home Team or under Other Teams.

EXISTS:A:$$EXISTSMOD=NOTEXISTS

EXISTS:A:$$OBJCODE=USRGPS

EXISTS:A:groupID=ID HERE

EXISTS:A:userID=FIELD:ID

isActive=true

isActive_Mod=eq

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

Nichole

2 replies

NicholeVargas
Adobe Employee
NicholeVargasAdobe EmployeeAccepted solution
Adobe Employee
April 6, 2022

Jill,

This is possible using an EXISTS filter within a User Report. You'll want to switch to text mode and replace ID HERE with the ID of the specific group. This will pull in a list of all active users who do not have that group listed as either their Home Team or under Other Teams.

EXISTS:A:$$EXISTSMOD=NOTEXISTS

EXISTS:A:$$OBJCODE=USRGPS

EXISTS:A:groupID=ID HERE

EXISTS:A:userID=FIELD:ID

isActive=true

isActive_Mod=eq

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

Nichole

JillAcAuthor
Level 10
April 7, 2022
Thank you!!!
LAM3
Level 2
April 22, 2025

I'm trying to figure out the text mode to show that users aren't in one of 2+ different groups. 

 

Text mode is showing me:

otherGroupIDs=666a12910042679c44c465408c8e95be	678939ab00023e398eb15a849993c7d0
otherGroupIDs_Mod=notin

And the report that shows me users that are in both groups. What is the text mode to show me users that aren't in group 1 or group 2? 

skyehansen
Community Advisor and Adobe Champion
April 22, 2025

I think it would work to use the same code from here:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-to-find-all-users-who-do-not-belong-to-a-specific-group/m-p/483004#M15773

 

and then separate your two groupIDs with a tab.

LAM3
Level 2
April 22, 2025

Thank you! I was missing the part about the tab to list all of the groups. Now it works!