Expand my Community achievements bar.

Check out the upcoming December events for Workfront System Administrators!
SOLVED

How to Filter a Project, Program, or Portfolio report or list based on who it's Shared-With

Avatar

Level 4

I am trying to run a report filtered according to who the object is shared with (e.g. Shared with X Group or System-Wide) but I do not know how to add that as filter. I have the "shared-with" field in my view so I know I can get at the data but struggling to filter on it. Any help appreciated! 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

hi Matt, the object controlling sharing for most of the objects, is called Access Rules, but in the API explorer you'll find it under Share.

 

Since it is a collection (i.e. your project object is shared with a collection of users, groups, etc., you would have to call on it using an exists filter)

 

Syntax for this looks similar to what you can see in this post:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/forms-shared-system-wide/m-p/48...

 

You would swap in different GUIDs for the accessorID line (e.g. your groupID would go here).

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

hi Matt, the object controlling sharing for most of the objects, is called Access Rules, but in the API explorer you'll find it under Share.

 

Since it is a collection (i.e. your project object is shared with a collection of users, groups, etc., you would have to call on it using an exists filter)

 

Syntax for this looks similar to what you can see in this post:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/forms-shared-system-wide/m-p/48...

 

You would swap in different GUIDs for the accessorID line (e.g. your groupID would go here).

Avatar

Level 4

Thanks, Skye. I think this is exactly what I was looking for. One clarification

 

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

 

In line #3 (EXISTS:A:accessorID=PUBLIC) is PUBLIC the same as SHARED SYSTEM WIDE?

Avatar

Community Advisor

yes, the public indicates it is shared system wide.