How to avoid duplicate records in date base view?

subbarayudu
Tera Contributor

I have created a data base view to incident, metric definition and metis instance table. When i am filtering the records in report getting duplicate records. 

Can you give any suggestion to avoid duplicate records and any this needs to be change in the clauses

subbarayudu_0-1675349407727.png

subbarayudu_1-1675349540252.png

 

2 REPLIES 2

arundharmabe
Tera Guru

Hi Subbarayudu,

Did you found any solution for this issue? Kindly let me know.

 

Regards,

Arun

KevinBellardine
Kilo Sage

Hey @arundharmabe 

This looks like a copy of the incident_metric database view. You're basically pulling all the metric instances that have been created for incident, but you're always going to have some "duplicates".

 

That's because what it's actually showing is the record from each time a metric has been created, and it's expected that many metrics would trigger more than once. For instance, if it's configured for assignment group you'd have multiple rows for a single incident, representing each time the assignment group was changed.

It might be less confusing if you pull in the Definition column, you could filter out what you don't want or at least show that the entries represent different definitions.