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]

In that case, you need to add more mapping ( where clause ) for excluding some record based on condition.  

[Elizabeth26]

In the where clause we use childtable.parent_case= maintable.sys_id

[AshishKM]

only one condition with two tables ?

maintable.sys_id or maintable's case record sys_id 

[Amit Gujarathi]

HI @Elizabeth26 ,
I trust you are doing great.
You can use below video for refrence.

[AndersBGS]

Hi @Elizabeth26 ,

As I understand you have created a relation between parent and child e.g. incident.  If this is correct, then this is as expected when creating a database view. If you have one parent with two child incidents, then there will come two rows:

Parent --> Child 1 incident

Parent --> Child 2 incident 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders