Hi
I have just started using Hibernate Search.
I have a case where I need to find all Stores matching a given keyword and also should be within a radius. The input will be lat and long and radius.
1. Each store has its name, lat and long as property. 2. I have a associated table which has store id, distance columns. This is populated dynamically each time a query comes in with lat and long and radius. It will be populated with all store ids and distance which falls within a given radius 3. Store is the main table and it has an associated IndexEmbedded property for the distance table
I have created a lucene query with matching api.
Suppose there are 5 stores with a matching name and in the second table there are only 3 stores which actually fall within the given radius, the results of the query is returning all 5 stores.
how should I restrict the results in this case ?
Any help is appreciated. Thanks Ansu
|