I am trying to get a View to have only a selective range of referenced content in it's exposed filter, but not having any joy so far.
This is the scenario:
Content type of Organisation can have one or more Roles. Each Role has a field; organisation; which refers to the Org it belongs to.
I built a View listing the Roles, and can expose the field:organisation belonging to the role. This gives me a select box listing all of the Orgs, not just the ones that have roles attached.
Using entity references from another View, I managed to get the select box to be just those orgs with roles, but submission of the search with only an Org selected that I know has roles would result in an empty result set, so I figured that I must be doing it incorrectly.
Any clues? I'll paste the View export below.