Sorry to be yet another question about entry reference relationships in views, but I can't find the answer in pre-existing questions.
the content type "page" has an entity reference field "artref" that references multiple nodes of the content type "article"
the content type "article" has a boolean field "fishy"
How do I create a view that shows all pages which reference at least one article where fishy is checked.
I understand that here are 4 relevant settings:
the basic entity bundle (pages or articles) selected for the view
the relationship type ("content referenced from" or "content using")
"require this relationship" setting
Aggregation, especially if "distinct" is a possibility
All advice much appreciated