Report on table change_task : access to this content denied based on report_view ACLs

Go to solution
WA1
Kilo Sage

‎07-17-2023 05:01 AM

Hello, 

I have a user who cannot see a report on table "change_task", the following error message is displayed: Access to this content is denied based on report_view ACLs.

I have checked the report_view ACLs, I have only 2 ACLs the first one requires "itil" role and the other one requires "snc_internal" and my user has both roles. 

I checked also the business rules and I don't have any on-query business rules.

 

For information when I added the role "project_user" to my user, he had access to the report but I don't know where is this restriction to have the role "project_user" to be able to see the report..

 

Thank you in advance

0 Helpfuls
  • 1,606 Views
1 ACCEPTED SOLUTION

Go to solution
WA1
Kilo Sage
In response to Ahmmed Ali

‎07-17-2023 07:17 AM

The group by is on the active field so it won't cause a problem.

I found that the report's type is multi-level pivot table and it requires 2 fields (column and row) that are in another table which has an ACL report_view with the role "project_user" inherited from another table.

To resolve this, I've created a new ACL report view on the table containing the 2 fields. 

 

Thank you for your help 🙂 

View solution in original post

0 Helpfuls
5 REPLIES 5

Go to solution
Jaspal Singh
Mega Patron
Mega Patron

‎07-17-2023 06:00 AM

Hi,

Can you try removing the GroupBy clause once, if any & run the report.