Expand my Community achievements bar.

SOLVED

I need to identify if a project has the Inherited Permissions turned on or off

Avatar

Level 3

I need to identify if a project has the Inherited Permissions turned on or off.  I have a report that I have the column share:isInherited and it is Boolean but it appears to display False for all projects whether it has Inherited Permissions turned on or off.  Am I looking at the wrong flag for Inherited Permissions being off or on - If so can anyone direct me to the correct flag.

1 Accepted Solution

Avatar

Correct answer by
Level 9

In my instance, I built a Project report and put this text mode in a column. The results are simple and ugly, but accurate. For a project where inherited permissions are turned off, all values that result in the column will be false. For a project where anyone is inheriting permissions through a role, group, team that the portfolio or program is shared with etc. - one or more of the values in the column will be true.

 

There may be some way to filter it down prettier, but if I had to do it quickly, I'd just dump the report to Excel and manipulate.

 

displayname=Access Rules
listdelimiter=<br>
listmethod=nested(accessRules).lists
textmode=true
type=iterate
usewidths=true
valueexpression=CONCAT({isInherited})
valueformat=HTML
width=200

 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 9

In my instance, I built a Project report and put this text mode in a column. The results are simple and ugly, but accurate. For a project where inherited permissions are turned off, all values that result in the column will be false. For a project where anyone is inheriting permissions through a role, group, team that the portfolio or program is shared with etc. - one or more of the values in the column will be true.

 

There may be some way to filter it down prettier, but if I had to do it quickly, I'd just dump the report to Excel and manipulate.

 

displayname=Access Rules
listdelimiter=<br>
listmethod=nested(accessRules).lists
textmode=true
type=iterate
usewidths=true
valueexpression=CONCAT({isInherited})
valueformat=HTML
width=200

 

Avatar

Community Advisor

I added this to the value expression to make it a bit more palatable:

valueexpression=IF({isInherited}=true, CONCAT({isInherited}), "")