Duplicate rows in Database view

[rohanbhatia]

Hi, I am trying to create a DB View for reporting purposes. But I ended up getting duplicate rows. 
Here we are using response and resolution SLAs on case table. At a time one response and one resolution sla can be active on case. 
DB VIEW:

Duplicate record list:

[palanikumar]

Hi,

There are two possibilities:

1) You have multiple response / resolution SLAs configured

2) Multiple SLA record created due to priority changes or any other changes based on your SLA configuration

If you have multiple response / resolution SLAs configured then you need to add condition to filter a specific SLA definition

If you have Multiple records created due to priority changes, then you can add a condition to exclude all the SLA records: Stage Not Equals to Cancelled (stage!=cancelled)

[rohanbhatia]

I added a extra filter as u suggested but still having the same issue : 

[Ankur Bawiskar]

@rohanbhatia 

if you have multiple SLAs running against your record then this is OOTB behavior i.e. DB view will show multiple records.

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

[rohanbhatia]

Hi @Ankur Bawiskar, 

Is there any other way to do this as i want to create a report in which i can see case number and sla response breach time and sla resolution breach time in the same row. without any duplicate rows.