question Need to show only the latest start time based record in task_sla table report in Community Central forum

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

Arka Banerjee — Mon, 25 Aug 2025 11:33:30 GMT

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

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

GlideFather — Mon, 25 Aug 2025 11:40:49 GMT

Hi @Arka Banerjee,

how did you configure this?

If it is by script, you can use something like:

slaGR.orerdBy('created_on');

slaGR.setLimit( 1 );

Which will sort it by the creation date and then you select the only 1 record so it will be always the latest one

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

Ankur Bawiskar — Mon, 25 Aug 2025 11:46:50 GMT

@Arka Banerjee

I believe you are using task_sla table and yes 1 HR case can have multiple SLAs attached to it.

you can create database view by joining task_sla and HR case table

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

Mark Manders — Mon, 25 Aug 2025 11:47:47 GMT

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'.

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

Arka Banerjee — Fri, 29 Aug 2025 11:32:41 GMT

Hi Ankur,

How do I restrict it to show a single SLA per case(the latest SLA) after creating the database view. Could you please help me with the same asap.

Thanks!

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

Arka Banerjee — Wed, 03 Sep 2025 10:22:31 GMT

Hey Ankur,

Any update?..

Regards,

Arka