Hi there,

I have a problem with de combination of the following modules: Views, Profile2, Field Collection and Location.

I have a user profile that has a Field Collection field. In that collection there is a location field from the Location module.

The problem is that I want to sort on the different address fields within the location field (like Country and Province) and I somehow can't do that.

When I add a new field in Views I can only add the complete location field (formatted), not the separate fields.
However, when I add the Location field from the user type, I CAN select the different location fields, though these locations are from the user itself, not the field collection items.

My setting:

User view -> Relationship to User: Profile (Profile2 module) -> Relationship to Field collection field (withing User: Profile).

My question: How can I use the separate locationfields from a Field Collection within Views?

Sideinfo: It's a site on wich the teachers can add their courses with dates and locations, thats why I used Field Collection.

Structure: User -> Profile (teacher) -> Classes/Courses -> Locations.

Thanks in advance for any help!

PS: This is a live site, so if I could do this with my current setup it would be great!

Comments

ikeigenwijs’s picture

ikeigenwijs CreditAttribution: ikeigenwijs commented

i have kindof the smae problem and set up

Structure is like following

User
--Collection Field(
--LocationA
--Collection Field(
--LocationB
)
)

I can show the location B as full adres.
But i need the street and other field as separate fields in the view

I have the collection field view module

keraweb’s picture

keraweb CreditAttribution: keraweb commented
Category: Support request » Bug report
Priority: Normal » Major
Issue tags: +collection field, +#views, +#views #location, +Field collection
plato1123’s picture

plato1123 CreditAttribution: plato1123 commented

I'm running into more or less the same issue. I can display the full address with a view (Profile: Address (Address)) but how to show only the zip code?

edit: On my view I added an additional "relationship" to "(Profile owner) Profile: Address" and then was able to add the additional field "(Location from field_address) Location: Postal Code (Postal Code)" and was able to filter by that and make it exposed.