I'm using Views 3 and Field collection 7.x-1.0-beta3. As a simplified example, say I've a field collection called Image - which itself has two fields, an image file and a text caption. My content type, Page, includes a multi-value field to reference one or more Image(s).
In my view, I want to list several Page nodes, and display the image file field taken from only the first of each node's referenced Image field collection entities.
This works, but...
I have one solution that does work but feels clunky and indirect: Add the Image collection-reference field, and use the multiple-value settings to restrict to the first value (a la this post). However, then I have to have a view mode for the Image field collection that prints only the image file field, in the desired image style.
What would be awesome:
I've tried a different route using the Relationships settings. I can add a relationship from node to its Image field collection. Then, I can add the image file field, pulling from the relationship. BUT, that creates a new result for each of the Image field collections being referenced... and I can't find an option to key the relationship off the first value only (similar to displaying only the first value when I'm just going through adding the field, in my "this works" solution above).
I realize this may be impossible - if Views can't create the necessary query? Just wondering if I have missed something though I've gone through the settings several times.
Edit: Drupal 6 / Views 2 does it!
Okay, I'm not crazy - see screenshot. I think that's exactly what I'm looking for here.