How to find all users who do not belong to a specific group? | Community
Skip to main content
J
JillAc
New Participant
April 6, 2022
Solved

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

  • April 6, 2022
  • 2 replies
  • 728 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!

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

LAM3
LAM3
New Participant
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
skyehansen
New Participant
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
    LAM3
    New Participant
    April 22, 2025

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

    N
    NicholeVargasAccepted solution
    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

      J
      JillAcAuthor
      New Participant
      April 7, 2022
      Thank you!!!
      Terms & ConditionsAccessibility statement

      Loading footer...