Answers.Body: <p>You can do it with search kit as below. The key part is the &quot;With (Optional)&quot; for the activity restricted by type and then the &quot;activity id is empty&quot; in the where clause. Obviously use &quot;Ceremonial&quot; instead of Meeting for the activity type, and you can add case status = Successful in the where clause.</p>
  <p><a href="https://i.sstatic.net/pNRXM.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/pNRXM.png" alt="enter image description here" /></a></p>
  <p>As an aside, one of the earliest features in civicase was an &quot;audit&quot; feature that was meant for this kind of thing - finding and acting on cases where part of the workflow was incomplete. But it was a bit of an experiment and never panned out.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-20T07:39:00.670Z
Answers.Text: Thank you so much; that is such a helpful response. What an amazing community!
Answers.UserDisplayName: Simon Thornton-Wood
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-17T15:16:03.190Z
Answers.LastActivityDate: 2022-09-17T15:21:11.370Z
Answers.LastEditDate: 2022-09-17T15:21:11.370Z
Answers.UserDisplayName: Demerit
Body: <p>I have created an Activity Type &quot;Ceremonial&quot; to attach to Contacts via Cases, which I am using to track qualifications we have awarded, honours we have granted and Fellows that we have admitted to membership. Each has an opportunity for ceremonial admission to the organisation. I am now trying to find those Contacts with Cases of Status=&quot;Successful&quot; to which an Activity &quot;Ceremonial&quot; needs to be attached (so we can track whether the Individual has participated in a Ceremonial for their Award). I have attached the Activity to some Cases as they have been processed, but not all, and so want an efficient method to identify the rest.</p>
  
Tags: <civicase><activities><search>
Title: How can I search for contacts without a specific Activity Type?
ThreadText: # How can I search for contacts without a specific Activity Type?
  
  (Asked by: username_0 on 2022-09-17)
  
  I have created an Activity Type "Ceremonial" to attach to Contacts via Cases, which I am using to track qualifications we have awarded, honours we have granted and Fellows that we have admitted to membership. Each has an opportunity for ceremonial admission to the organisation. I am now trying to find those Contacts with Cases of Status="Successful" to which an Activity "Ceremonial" needs to be attached (so we can track whether the Individual has participated in a Ceremonial for their Award). I have attached the Activity to some Cases as they have been processed, but not all, and so want an efficient method to identify the rest.
  
  **Tags:** civicase, activities, search
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-09-17. Score: 1
  
  You can do it with search kit as below. The key part is the "With (Optional)" for the activity restricted by type and then the "activity id is empty" in the where clause. Obviously use "Ceremonial" instead of Meeting for the activity type, and you can add case status = Successful in the where clause.
  
  [![enter image description here](https://i.sstatic.net/pNRXM.png)](https://i.sstatic.net/pNRXM.png)
  
  As an aside, one of the earliest features in civicase was an "audit" feature that was meant for this kind of thing - finding and acting on cases where part of the workflow was incomplete. But it was a bit of an experiment and never panned out.
  
  > **Comments:**
  > **username_0**: Thank you so much; that is such a helpful response. What an amazing community!  
  
  ---
  
  