Duplicate rows in Database view

rohanbhatia
Tera Contributor

Tuesday

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:

rohanbhatia_0-1757422016774.png

Duplicate record list:

rohanbhatia_2-1757422107736.png

 

 

0 Helpfuls
  • 307 Views
6 REPLIES 6

Bhuvan
Kilo Patron

Tuesday

@rohanbhatia 

 

If multiple SLAs are attached to case, it is expected to show that many number of records. case to SLA is a one to many relation and it is expected behavior.

 

See below thread where I provided more information,

 

https://www.servicenow.com/community/performance-analytics-forum/reporting-help/td-p/3374058

 

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

0 Helpfuls

Bhuvan
Kilo Patron
In response to Bhuvan

53m ago

@rohanbhatia 

 

Did you get a chance to review this as I believe the information provided should answer your question

 

If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

0 Helpfuls