Assignment Report Help? Projects that do not have xyz assigned.

[Christina_Jarosz]

Guys I'm stuck!

I'm trying to determine of which projects owned by xyz team were not assigned a graphic designer role.

I can't seem to grab this somehow. Is it an assignment report of all projects that do not have a graphic designer role as part of a project user? A task report that shows projects that do not have any time tracked by a graphic designer? A project report that does not have a graphic designer attached?

Every time I try it I'm just not getting it. What am I missing?

[skyehansen · Accepted solution]

I'm looking at the API explorer and it looks like a project report using an exists statement and the project user roles collection might work? (never tried it myself) If that one doesn't then the project users collection would also probably work but only exposes the primary role (so someone with a secondary role of graphic designer wouldn't show not up)