Answers.Body: <p>civicrm_activity.is_deleted is only used by civicase. Regular activities disappear. If you have logging at administer - system settings - misc turned on then log_civicrm_activity will have them where log_action = delete.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-13T16:19:53.913Z
Answers.Text: Thanks, appreciated, I can see the deletes in the log_civicrm_activity table  A pity that search kit doesn't allow searching the log table - guess I'll have to use Drupal Views if the user really does want a report
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-13T16:33:24.967Z
Answers.Text: In theory you could see it with the CiviReport Contact Logging Summary, but that report is iffy for anything that isn't a Contact, and isn't good with activities.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-13T20:13:06.137Z
Answers.Text: So not highly recommended then!!
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-14T07:47:17.107Z
Answers.Text: Maybe a separate question, but how to add a log.civicrm.xxx table to Drupal Views? I've addded it to settings.php, cleared caches but nothing doing.
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-14T10:52:49.800Z
Answers.Text: I'd ask it as a separate question then the views experts will see it.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-13T12:49:00.353Z
Answers.LastActivityDate: 2022-04-13T12:49:00.353Z
Answers.UserDisplayName: Demerit
Body: <p>Is it possible to run a report on deleted activities? There's an is_deleted flag in the civicrm_activity table which isn't exposed by search kit and I can't find any is_deleted flags set to anything other than zero. And deleted activities do disappear from the above table. Would a logging table hold the deleted activities? it doesn't look like it, after trying out a delete on another site.  Civi is at 5.47.4 &amp; Drupal 7.</p>
  
Tags: <activity><deleted>
Title: Is it possible to report on deleted activities/
ThreadText: # Is it possible to report on deleted activities/
  
  (Asked by: username_0 on 2022-04-13)
  
  Is it possible to run a report on deleted activities? There's an is\_deleted flag in the civicrm\_activity table which isn't exposed by search kit and I can't find any is\_deleted flags set to anything other than zero. And deleted activities do disappear from the above table. Would a logging table hold the deleted activities? it doesn't look like it, after trying out a delete on another site. Civi is at 5.47.4 & Drupal 7.
  
  **Tags:** activity, deleted
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-04-13. Score: 2
  
  civicrm\_activity.is\_deleted is only used by civicase. Regular activities disappear. If you have logging at administer - system settings - misc turned on then log\_civicrm\_activity will have them where log\_action = delete.
  
  > **Comments:**
  > **username_0**: Thanks, appreciated, I can see the deletes in the log_civicrm_activity table  A pity that search kit doesn't allow searching the log table - guess I'll have to use Drupal Views if the user really does want a report  
  > **username_1**: In theory you could see it with the CiviReport Contact Logging Summary, but that report is iffy for anything that isn't a Contact, and isn't good with activities.  
  > **username_0**: So not highly recommended then!!  
  > **username_0**: Maybe a separate question, but how to add a log.civicrm.xxx table to Drupal Views? I've addded it to settings.php, cleared caches but nothing doing.  
  > **username_1**: I'd ask it as a separate question then the views experts will see it.  
  
  ---
  
  