Report on Subgroup | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
November 20, 2023

if you're talking about the other groups that a user belongs to (i.e. "other groups" rather than "sub group"), I would recommend using an exists statement. This would vary based on the report you're creating, but here are a few samples of code you might use:

https://experienceleaguecommunities.adobe.com/t5/custom/page/page-id/GlobalSearch#q=exists%20usrgps&sort=relevancy&f:@el_contenttype=[Community]&f:el_product=[Workfront]

K
Kasey-GagneAuthor
Level 5
November 22, 2023

Thank you! Yes, I'm referring to "other groups". I am looking to utilize it in a Calendar where we're showing everyone's Time Off. 

 

Currently we have all of our users within the Marketing group -- then break them out into Subgroups (or "Other groups"). I am looking to organize the Time Off calendar to organize them based on other groups they are a part of so that you don't always have to view ALL of marketing. 

 

I tried taking a look at the link above but can't seem to find a solution 😞 

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
November 29, 2023

I think this might still have to be an exists statement. I also have a feeling that exists statements don't work in a calendar? However, you could try the following in a Time Off report and see if that would suit your team/group?

 

EXISTS:a:$$OBJCODE=USRGPS
EXISTS:a:userID=FIELD:userID

EXISTS:a:groupID=____________________ (separate multiple IDs by tab characters)

Terms & ConditionsAccessibility statement

Loading footer...