I'm working on a Drupal 7 site that shows the projects done by the researchers in an organization. The Projects content type has a field collection of researcher first, researcher last and role. The role is important because some researchers are the primary researcher and others take a more supporting role. These are not roles in the sense of Drupal user roles, but roles that are internal to the organization. Roles are a taxonomy with a term reference in the field collection.
There are two filters needed: 1. A filter by last name no matter what the role 2. A filter by last name where the role is primary researcher
I found this resource, which got me started: http://drupalcampnj2014.drupalcamp.org/sites/default/files/slides/working_with_field_collections_0.pdf
I have set the view to Aggregation On and I have created a relationship with the Field Combination. But I still see no way to filter on a specific field.