Filter a view by a field on a referenced entity Sorry to be yet another question about entry reference relationships in views, but I can't find the answer in pre-existing questions.

Given:


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
I figured it out. Configure in this sequence:


Show: "content" of type "page"
Relationships: "Content referenced from art_ref"
Use Aggregation: Yes
Add filter criteria: fishy, Aggregation: "group results together", relationship: "art_ref:content", operator: "is equal to" "1"