Drupal Association members fund grants that make connections all over the world.
Please feel free to let me know if you think this belongs in Views rather than here.
I'm creating an event calendar.
I have a content type called "Event" and a content type called "Library".
Libraries have locations.
Events have either a library (via an entity relationship) or a location of their own (some events don't happen at libraries).
I need to filter my View, which collects Events, by the event location (specifically by county).
In some cases, the location is coming from a field in the referenced Library, via a Views relationship.
In other cases, the location is a field in the Event itself.
I can filter either on the library location (via a relationship) or on the Event's own location, but I need both - I need the user to select a county and see all events in that county, whether they're at a library or not.
My problem is, I can't create a single exposed filter to operate on locations that may be coming from two different sources.
Do I need to somehow pull the library location into the Event, so that all Events have locations, whether or not they're at a library?