Case deletion

[irvken]

Should I be able to delete these cases  completely as I can with contacts?

[mathieu]

CiviCase works mostly under the assumption that information put in the system can never be deleted. For example, modifying custom data of the case will create a "change custom data" activity, or changing the case start date, status, etc, generates an activity to help track the changes done to a case.

[petednz]

if we have a mistake made where a contact ends up with 2 cases instead of one, what is the best approach for deleting one of them?

[demeritcowboy]

There's a merge cases link kind of hidden in the middle of the screen on manage case, on the left under the dropdowns. I think it only shows up if there are at least two open cases for the same contact.

[petednz]

So I see - thanks for pointing that out - but it leaves the 'deleted' case in the db - and hence is forcing us to tweak lots of forms etc to filter out 'is deleted'

I think I am still hoping that there is a 'delete permanently' option just as there is with civi contacts.

I am taking it this doesn't exist, and I should continue to work around this, find a sql query that will do the full clean out of case, relationships with the case ID, activities with the Case ID etc,

or suggest a patch that adds this option but presumably with an extra permission for it too. thoughts?

[Erik Hommel]

I am afraid that is the case Pete 

[mathieu]

For what it's worth, deleting with "delete from civicrm_case where is_deleted = 1;" should delete everything, since there are foreign key relations to the other tables (activities, relations) with the option "on delete cascade".

[petednz]

Eileen reckons the above wont work as you would also need

Code: [Select]

DELETE c, ca, a FROM
civicrm_case c LEFT JOIN
civicrm_case_activity ca ON c.id = ca.case_id
LEFT JOIN civicrm_activity a ON ca.activity_id = c.id
WHERE case_id = 246;
but Eileen also reckons that via the api works

CRM.api('case', 'delete', {'id' : xxx});

[petednz]

I posted a question on this topic to http://civicrm.stackexchange.com/questions/176/how-should-i-delete-a-civicase-or-a-case-type/177#177

please help improve it