I'm stuck with a query issue that at present seems unresolvable. Hoping the community has some insight to this.
My index contains events that have multiple beginning/ending date ranges and multiple locations. For example, event A (uniqueId = 123) occurs every weekend, sometimes in one location, sometimes in many locations. Dates have a beginning and ending date, and locations have a latitude & longitude. I need to query for the set of events for a given "area", where area = bounding box. So, a single event has multiple beginning and ending dates and multiple locations. So, the beginning date, ending date, latitude and longitude values only apply collectively as a unit. However, I need to do range queries on both the dates and the lat/long values. Any suggested strategies for indexing and query formulation? thanks, j
