Database View - Duplicate Records under Reporting

[Elizabeth26]

We have a database view that's used for reporting. It ties multiple tables together. However, when you report out you get duplicate cases because each child record appears as well. Is there any way to filter out the child records from reporting? 

[AshishKM]

Hi @Elizabeth26 , 

You need to re-visit the DB view table's column mapping with other tables. 

Some of table mapping is giving this duplicate result.

You can disable some mapping and test the result. 

-Thanks,

AshishKM

[Elizabeth26]

Do you mean in the Where clause? 

How can we pull the data from those tables without it actually showing the cases multiple times?

[AshishKM]

yes, in the where clause.

if the result is completely duplicate then you need to check the where clause condition 

else, if only some columns has same values then its not a duplicate.

[Elizabeth26]

It's not a complete duplicate. It has additional field information we need but we don't want it to count towards the case count.

childtable.parent_case= maintable.sys_id