Project Report with Project Users Collection based on Role & Home Group

[MoniqueEvans]

I'm working on a new view for a project report and am having a bit of text mode brain fog. I would like to pull in the Project Users but only include those from a specific homegroup and exclude a home team. I'm able to pull the list for Home Group but cannot remember how to do a "not_in" for the role? Is that even possible.

displayname=Creative Studio
listdelimiter=<div>
listmethod=nested(projectUsers).lists
type=iterate
valueexpression=IF({user}.{homeGroupID}="GUID",CONCAT({user}.{name}),"")
valueformat=HTML

[skyehansen]

the role is a collection on the user object. Documentation probably says "no collections of a collection" -- would you be content with just the primary role? As a quick workaround you could probably indicate that if the primary role is XYZ, do "", otherwise, concat the user name. 

In case you meant to say "team" instead of "role", the same is true -- can't look for all teams, but can look for the home team.

[MoniqueEvans]

Thanks Skye! That's what I was afraid of, I could list every role (or team) except for the project manager but was hoping for something a little cleaner so it didn't take 5 minutes to load due to the lenghtly complex filter.

Before I go through that trouble, I'll check in with the team and see if it bothers them that there's an extra name included.

[nryan2]

Would something like this work:

displayname=Creative Studio

listdelimiter=<div>

listmethod=nested(projectUsers).lists

type=iterate

valueexpression=IF({user}.{homeGroupID}="GUID",IF({user}.{homeTeam}.{name}!="Your Team Name",CONCAT({user}.{name}),""))

valueformat=HTML