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