How to make reports follow table level ACL?

chekjun
Tera Contributor

When creating Single Score report on Incident table, the total number shown is inclusive of all Incidents. When I click on the number however, the list view is shows only the reports which should be visible (as configured by the ACL on Incident table) which is the intended behavior. Is there any way to make the total count on the report only include the records that should be visible to the user?

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @chekjun 

 

No, the report is just fetching the count, not the actual records. The visibility of the actual records is based on ACLs, so there will be a difference.

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG thank you for the clarification. Would like to ask whether it is possible to filter the total count to match the visibility for records set by table acl?

Hi @chekjun 

I'm not 100% sure, but to verify, you need to open the ACL. There, at the bottom, you should see the condition, and it will also display the record count.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************