1

We are trying to delete the change log for 1 user. We want to complete remove their address and information on our system. There a way to delete the change log for 1 contact in CiviCRM?

3
3

It depends on what you are trying to do. If you want the complete removal of the contact, together with related entities (like address, activities, event participations etc.), then permanently deleting the contact will delete all the associated entities.

If you just want to remove the change log for that 1 contact without deleting the contact, you can run a simple SQL query to delete it. For a contact with the contact id 57 you would run this:

DELETE FROM `civicrm_log` WHERE entity_table LIKE 'civicrm_contact' and entity_id = 57

Beware, if you used something like Drupal webforms, then the data can still be there in the webform submissions, even though you deleted it form CiviCRM.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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