Dashboard report doesn't show any record

Community Alums · ‎12-27-2023

Hi experts,

I have a report on my dashboard of type score. Now I used a script to return the sys_ids that I want, the issue is I'm getting all the sys_ids but the count remains 0. Does anyone know what's going on with my script or report filter (report also follows interactive filter, just mentioning).

I have attached the screenshot of my report and also the script include.

Then I also used "sys id is javascript&colon; new scriptName().function()" in screenshot report 2

Thanks in advance!

Dr Atul G- LNG · ‎12-29-2023

Hi @Community Alums

Agree, in this case what I suggest

let's try to build this report on list view first and see how many records in this year and last year. This will help us to see what wrong we are doing.

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

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

View solution in original post

Community Alums · ‎12-28-2023

I set the limit to 2 so I can see the condition clearly, as you can see I have 2 sys_ids and still count is 0.