Author Topic: Case deletion (Read 1258 times)

irvken · January 27, 2014, 01:48:04 am

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

mathieu · January 27, 2014, 05:45:04 am

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 · January 27, 2014, 12:53:53 pm

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 · January 27, 2014, 02:37:32 pm

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 · February 02, 2014, 09:28:05 pm

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 · February 03, 2014, 12:41:53 am

I am afraid that is the case Pete

mathieu · February 03, 2014, 06:14:35 am

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 · February 18, 2014, 04:19:40 pm

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 · March 29, 2015, 03:55:59 pm

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

CiviCRM Community Forums (archive)

News:

Author Topic: Case deletion (Read 1258 times)

irvken

Case deletion

mathieu

Re: Case deletion

petednz

Re: Case deletion

demeritcowboy

Re: Case deletion

petednz

Re: Case deletion

Erik Hommel

Re: Case deletion

mathieu

Re: Case deletion

petednz

Re: Case deletion

petednz

Re: Case deletion