I have three content types Projects, Campaigns and Blog Posts. Campaigns and Blog Posts share an entity reference field that allows for selection of one or more related Projects.
I currently have a View with block that is displayed on the individual Project nodes and lists Blog Posts that are related to that Project. There is a contextual filter to compare the array of related (Project) nodes within the Blog Posts with the ID of the current Project node. I want to add the same type of list to the individual Campaign nodes.
The Campaign nodes will have one or more referenced Projects and the Blog Posts must be compared to see if they share any of the referenced Projects in common.
For example Campaign 1 with references to:
- (Project 1, Project 2, Project 3)
should show related Blog Posts with either:
- (Project 1)
- (Project 2)
- (Project 3)
- (Project 2, Project 3)
- (Project 1, Project 3)
- (Project 1, Project 2)
- (Project 1, Project 2, Project 3)
I have read and tried a couple of possible solutions to configure the contextual filters and relationships, but nothing is working; the results are blank. I know for a fact that there is a Blog Post and a Campaign that share at least one common Project reference. So the results should show at least that one Blog Post.
Any ideas? Clearly defined configuration options would be appreciated.