This screencast shows some neat functionality for Entity Reference in Views, primarily how to use with Views relationships:
- Each (applicable) entity reference is available as a relationship.
- Also, each (applicable) entity reference is available as a reverse relationship. Sweet!
- Using relationships will give you duplicate rows – because that is how relationships work. (You get a new result for each join that the relationship makes.)
- You can also use entity references as contextual filters.
- When Entity API is enabled, you can choose the "show" setting entity, in addition to fields and content.
It is not demonstrated in the screencast, but entity reference fields can also be used as filters, sorting criteria and view fields. There is also a filter type that can be used – filtering on the type of entity referenced. Sorry for omitting this.
Modules: