How to exclude child cases from a report?

[Shilpa Mannoni1]

I have a report that lists all cases by case type. We need the report to only show parent cases and not the child cases associated. How can we achieve this?

[Ashir Waheed]

Hi @Shilpa Mannoni1 

I would recommend you to add the filter on the report.

1. Parent Case is Empty.

2. Child Case is Empty

These fields are available like for incident table but It would be much helpful if you can share the table name for which report is being created.

Since the Child cases must have the parent Case linked to them. You can use this filter to exclude the Child Cases. Then only remaining are the Parent Cases.

Regards,

Ashir Waheed