Is it possible to show data in report if there are ACL restrictions?

ServiceNow SA · ‎02-19-2021

Hi Team,

As per requirement, there are record level access on the table based on user role. Some users do not have permission to view those data.

We have query business rule and ACL in place for that.

However is it possible to show the reports based on all table data to those users? Basically there should be no restriction in report data for those users?

johnfeist · ‎02-19-2021

If you are asking if the users who are restricted by ACL and query BR can see those data in a report the answer is no. Query BRs run at a lower level than reporting and ACLs run below that.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

View solution in original post

Ankur Bawiskar · ‎02-19-2021

Hi,

So on the report they will only see the restricted data if you have query BR and ACL

You can somehow make Query BR not to run when the URL is report

Same goes with ACL within the script section

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Patrick71 · ‎10-24-2023

You could try field specific read + report_view ACLs. The Read ACL should be to restrict such users from seeing the field's data on the list/form, while the corresponding report_view ACL can grant those users visibility of those field(s)' data on a report.