I am struggling to create a SearchKit for the following usecase: I want to show a list of cases with their clients etc, but also with related contacts with a role on each case, e.g. the client's "Benefits Specialist" in our well-known "Housing Support". This is my approach so far:

enter image description here

As long as a client has only one case, things work as needed in the usecase (like in case id = 2). But as soon as a client has two or more cases, the grouping on case leads to a situation where I have all "Benefit Specialists" of all cases of these clients listed. In my example: Test Specialist 1 has a case role in case 1 and Test Specialist 2 in case 2 and both results are shown in the last column (it would even be worse, if I chose another field transformation).

There is no error here, this works as expected from my configuration. But: I have no idea how to solve the use case with SearchKit. Until now I used Data Processor for that where I just have to use the output handler "role on case" where I can map the case id and that's it. One solution would be to start with the entity contact, but I need the case actions here... Can anyone help?

1 Answer 1


UPDATE: This feature has now been added to CiviCRM. https://github.com/civicrm/civicrm-core/pull/28112

It seems like a missing feature, being able to link the relationship to the case. Or more generally, allowing SearchKit selectors to specify another entity in the search (e.g. making "Current Case" available in this dropdown):


It would be great to get that feature sponsored and included in SearchKit!

  • 1
    Yes, that would be really great. Maybe it would be good to make an issue out of it? I could imagine that funding could be found - I'll ask around too.
    – Andreas
    Oct 23, 2023 at 20:01
  • I was just hitting this recently as well in replacing the old CiviCase dashboard.
    – Andy Burns
    Oct 23, 2023 at 21:12
  • Andreas that sounds like a good plan! Please ping me on chat.civicrm.org about it.
    – Coleman
    Oct 23, 2023 at 21:34

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.