Report on Database view table not showing data

Jyoti Tripathi
Giga Guru

‎07-08-2025 06:33 AM

Hi, 

I’m encountering an issue with a report that does not displays SLA-related fields (like SLA Definition Name and Business Elapsed Time).

The report is built on a joined table (sn_hr_core_case and task_sla) that combines records and their associated SLA details.

JyotiTripathi_0-1751981489440.png

 

When the report is run as an admin, everything displays correctly — including all SLA-related fields.

JyotiTripathi_1-1751981628105.png

 

However, when I impersonate a non-admin user (e.g., HR agent), the SLA fields appear blank

JyotiTripathi_2-1751981664769.png

 




0 Helpfuls
  • 409 Views
5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Jyoti Tripathi

‎07-09-2025 01:18 AM

Hi @Jyoti Tripathi 

Please log a ServiceNow support case as well. One possible reason for the issue could be that the ServiceNow internal query is hitting an ACL range limit of approximately 70,000, which might be causing the problem.

*************************************************************************************************************
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]

****************************************************************************************************************
0 Helpfuls