Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

A report for shared reports

Avatar

Level 6

Workfront Community,

I may be overlooking the filter or report type but is there a way to filter a report for reports to only show reports that are shared with a specific user?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I just did some digging and could not find how to filter this either. You could create a report with no filter and then run the report as the specific user. This would then show all the reports they have access to. Definitely not the cleanest way to get the info, but it'll work.

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

I just did some digging and could not find how to filter this either. You could create a report with no filter and then run the report as the specific user. This would then show all the reports they have access to. Definitely not the cleanest way to get the info, but it'll work.

Avatar

Level 6

Thanks, Monique! It's working for what I need. One of our project admins is leaving so I'm making sure that the new admin has access to all the same reports, dashboards and project templates.

Avatar

Level 10
Level 10

Hi Jared, 

The below filter can be used in any type of report (reports, projects, tasks, issues, etc.) to return a list of records that are shared with a specific user. It will display records where access is either inherited or shared directly.

 

  • Swap out the GUID with the user's GUID.
  • This will not return records that a user can only access because the record was shared with their role, team, or group - it looks for records that were shared directly to the user.
  • If you want to return records that were shared to a specific role, team, or group, you can use the same filter and just swap out the ID of the role, team, or group. (You can enable multiple filters by layering in OR statements)
  • If you want to return records that AREN'T shared directly to the ID in the filter, you can change the EXISTSMOD from EXISTS to NOTEXISTS.

 

EXISTS:A:$$EXISTSMOD=EXISTS
EXISTS:A:$$OBJCODE=ACSRUL
EXISTS:A:accessorID=5c1e831f02dc1e4ae10d0c0134b7c072
EXISTS:A:securityObjID=FIELD:ID

In a nutshell, what this filter does is "show a list of _____ (whatever the object type of the report is) where a Sharing rule exists AND that Sharing rule is for the provided ID" 

Hope this helps.
-WE