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.

Need to show only the latest start time based record in task_sla table report

Arka Banerjee
Mega Guru

Hi Team,

 

I have created a few bar charts from view\run report module for HR case SLA's. The problem is for HR cases where multiple SLA's are attached, they are showing up as multiple records. I want to show only the latest start time based SLA record per HR case, so that each case shows up only once. Can you please help me with how I can achieve this.

 

@Ankur Bawiskar 

5 REPLIES 5

Mark Manders
Mega Patron

Please share the conditions of your report. If it's a simple report, you can't report on that, because when you ask 'I want to see xyz', it shows you 'xyz'. You can't say 'I want to see xyz, but not z'.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark