I’m having trouble using fields of nested field collection items in Views. If a field collection item isn’t nested within another field collection item, then I can get its fields displayed by views no problem (by creating a views relationship as explained in this Drupal Stackexchange page on integrating Field Collection Module in Views), but I can’t get it to work if the field collection item is nested within another field collection item. Here’s my example:
I have a content type with a field collection item called “Job.” “Job” has two fields in it, both of which are also field collection items, “Job Info” and “Equipment Info”. “Job Info” has two text fields, “Job Name” and “Job Date”, and “Equipment Info” has a text field called “Equipment Name”, and an integer field called “Equipment Value”. This pic illustrates the fields: http://i1102.photobucket.com/albums/g455/FilmSnob718/Drupal%20Question/F...
My goal is to have a view that simply lists all the individual equipment values:
When I set up this view as pictured in this screenshot http://i1102.photobucket.com/albums/g455/FilmSnob718/Drupal%20Question/V... the values in the view are blank and there are an incorrect number of them (3 instead of 8). The view ends up looking like this: http://i1102.photobucket.com/albums/g455/FilmSnob718/Drupal%20Question/V...
My hunch is that I need to create a second relationship in the view, but it’s still not working after trying lots of relationship combinations. To make things more illustrative for myself and others reading this post, I have set up a live mock site with this example (which I hope to maintain indefinitely for the benefit of others) at www.shakespeare79.byethost31.com/ feel free to login with the username ‘helper’ password ‘drupal’ to edit the view if you know how to get it to work. (Let me know if an additional module needs to be installed in order to achieve the task and I’ll install it). Thanks!