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.

1 Answer 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

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.

  • Thank you so much; that is such a helpful response. What an amazing community! Sep 20, 2022 at 7:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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