I ran a Case Detail Report to see a list of cases because my Views table count was not adding up. I realized from this report that there is a case with an "Active" status that does not have a Contact ID. I can't seem to find this case anywhere. The case is not "deleted" from what I can tell. Any ideas is appreciated!

1 Answer 1


It's weird to see a case without a client. Maybe, it was created correctly and somehow civicrm_case_contact table row was deleted for this contact_id?

If you wish to delete this case from your site, you can make use of the API explorer - http://site-name/civicrm/api#explorer OR can be navigated through Support -> Developer -> API Explorer

Use Case Entity with Delete action and pass the case id as a parameter -

enter image description here

If you don't know the case id - you can check by placing your cursor on the subject column of the case detail report. The URL will be shown on the bottom left of your browser which has the caseId param as shown in the screenshot -

enter image description here

  • 1
    Hovering over the subject for the case ID is a neat trick -- thanks!!
    – Kristine
    Commented Mar 29, 2018 at 21:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.