The website has two content types: Magazine and issue.
I'm using the Entity Reference module to create a magazine archive website.
I have a views that list all magazines. Each magazine is with an image of issue that related to this magazine. There is a relationship (entity reference: referencing entity) and the aggregation setting is active (use aggregation).
Everything is OK but there is a problem I couldn't solve.
The image for each magazine is the image of the first issue of this magazine. But not every "first issue" has an image and it shows the default image.
What I want to do is to show the first issue's image that's image field is non-empty or show any related issue's image on this views. How can I do that?
Note: Some magazine's any issues doesn't have any image and if I filter out these issues, then the related magazine will not be shown. I think what I want to do is if any of the issue has an image show it or show the default image.