I have a content type with 2 Field Collections(both set for unlimited values), they are Author and Editor. Both field collections are using the same fields(first_name and last_name).
In a Views that I created has both field collections displayed. And I would like to exposed the First and Last Name, but they are not searchable without a relationship. Meaning I have to have 2 First Name and 2 Last Name filters exposed with different relationships.
How to make 1 first name filter exposed and searchable for both Author and Editor?
PS: I have done many other searchable Views page, but this is different(2 field collections with same fields).