Skip to main content

Hi ,

 

I am looking for custom query which gives the result of roles and its capabilities

 

Like below

  

RoleCapabiltyStatusInteractorDownload the workbookyesInteractorFilteryesInteractorViewyesInteractorConnectyesviewerOnly viewyesviewerDownload the workbookNull

 

as we know viewer doesn't have the capability to download work i need to show a row along with status as null

 

Any one help me with what tables to join to get the desired output

 

TIA,

 

BR,

NB

1 answer
0/9000