I think you can use collections in the filter. Here's an example where using the collection of hours was used in a project report: hours:ownerID=57447046004e3416cee385ff9c223afc hours:ownerID_Mod=in The collection is hours and the field is OwnerID Collections Reporting : a. View the API Explorer at "https://developers.workfront.com/api-docs/api-explorer/"> https://developers.workfront.com/api-docs/api-explorer/
b. Find the object you want to get the list of items relating to (project, task, issue, user etc). c. Click on the Collections tab. d. Click on the data type you want. e. Copy the API Key into the green field below: f. Click on the URL to the collection object and click on the field you want and copy the API Key in the blue field below. g. Add a new column to a view or report and paste the below in text mode. Note that the report needs to be of the same type as the object you chose in step two. ------Original Message------ Hi All, Wondering if there is a way to generate a report that lists all completed projects that included a member of the team in any of the tasks.¬¨‚Ä† We are looking to see all projects completed in Q4 of 2017 from a small subset of designers.¬¨‚Ä†¬¨‚Ä† The closest thing I've seen has been a task report pulling from the "Assigned To" field, but there doesnt seem to be any option to do this at the project level.¬¨‚Ä† Note, this type of user would not be listed in a custom form, project owner/sponsor, etc.¬¨‚Ä† They would simply be assigned to a task within a project. If not, I'll probably have to manually log in to each designer and export from their "Projects Im On" section.¬¨‚Ä† As an admin, shouldn't I be able to generate a report of all projects any team members are currently assigned to? Andrew Daniels Gartner, Inc.