- Drupal 7, view 3 and field collection.
- I have a custom content type with a field collection called personal detail.
- Personal detail have 2 fields: name and contact.
Personal detail is zero to unlimited.
In view, I am able to display the values of 'name' field. The problem is there are multiple values for 'name' field. This caused me to have duplicated records (i.e. same node id appears more than once, because the 'name' field)
I only want to display the very first one value of 'name' field which is stored the order of a node.
Solution: In Go to field collection in view's relationship (right column)
There is a statement: The delta allows you to select which item in a multiple value field to key the relationship off of. Select "1" to use the first item, "2" for the second item, and so on. If you select "All", each item in the field will create a new row, which may appear to cause duplicates.
So select "1" will show the first fields.