Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Not able to view content of report

Akshaykhare
Tera Contributor

‎02-20-2025 10:55 PM

I have created a database view on Finance request table and sla_breakdown_by_assignment table and using the same to create report. But in the report I could only see the count of records at the end of the page and not the actual data(image attached for reference). I am an instance admin and I have the roles to view the report. You can see the where clause in the attached image. 

Akshaykhare_2-1740120924765.png



Akshaykhare_1-1740120858190.png

 

 

0 Helpfuls
  • 301 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-20-2025 10:59 PM

Hi @Akshaykhare 

 

When you are on DB view, could you please "TRY IT" and see results are appearing. Looking like where clause has issue.

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