I'm setting up a vew of cases of type "x" and using views relationships to pull in cases relationships such as "Case Worker for" Client- as well as client details.

If, I have a client who has had more than one case with the organisation. With a number of "Case Workers". how can I filter the view to only show the case relationship for the listed case?

Currently will now show duplicate lines or each case, 1 per case worker.

If I use views aggregator plus module, I can compress the view down to one line per case- but it is normally the first added case worker shows not the one for the specific case.

See screenshot for example- 1 client, 1 case, but 5 caseworker relationships to the client

case view screenshot

1 Answer 1


Ok, once again I should have looked more carefully at the suggested answers

If contact has multiple cases, how do I filter a view to show only case roles associated to that case type

Start with a relationship view Then pull in the case id from the views relationships and filter on the case type, relationship type and is the relationship active

And then bring in the related contacts

Thanks @pmoz and @ehommel

enter image description here

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.