This all looks fine, so the next question is whether or not your documents have the value you think.
+local_0_coordinate:[-23.6674 TO -23.6705] +local_1_coordinate:[-46.7314 TO -46.7274] is the actual translated filter. So I'd check the actual documents in the index to see if you have a single document with local_0 and local_1 that fits the above. You should be able to use the TermsComponent: http://wiki.apache.org/solr/TermsComponent to look. Or switch to stored="true" and look at search results for documents you think should match, just to see the raw value.... Who knows? It could be something as silly as you have your lat/lon backwards somehow, I've spent _days_ having problems like that <G>... Best Erick On Thu, Mar 29, 2012 at 2:34 PM, Alexandre Rocco <alel...@gmail.com> wrote: > Erick, > > My location field is defined like in the example project: > <field name="local" type="location" indexed="true" stored="true"/> > > Also, there is the dynamic that stores the splitted coordinates: > <dynamicField name="*_coordinate" type="double" indexed="true" > stored="false" multiValued="false"/> > > The response XML with debugQuery=on is looking like this: > <response> > <lst name="responseHeader"> > <int name="status">0</int> > <int name="QTime">1</int> > </lst> > <result name="response" numFound="0" start="0"/> > <lst name="debug"> > <str name="rawquerystring">*:*</str> > <str name="querystring">*:*</str> > <str name="parsedquery">MatchAllDocsQuery(*:*)</str> > <str name="parsedquery_toString">*:*</str> > <lst name="explain"/> > <str name="QParser">LuceneQParser</str> > <arr name="filter_queries"> > <str>local:[-23.6674,-46.7314 TO -23.6705,-46.7274]</str> > </arr> > <arr name="parsed_filter_queries"> > <str> > +local_0_coordinate:[-23.6674 TO -23.6705] +local_1_coordinate:[-46.7314 TO > -46.7274] > </str> > </arr> > <lst name="timing"> > <double name="time">1.0</double> > <lst name="prepare"> > <double name="time">0.0</double> > <lst name="org.apache.solr.handler.component.QueryComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.FacetComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.MoreLikeThisComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.HighlightComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.StatsComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.DebugComponent"> > <double name="time">0.0</double> > </lst> > </lst> > <lst name="process"> > <double name="time">1.0</double> > <lst name="org.apache.solr.handler.component.QueryComponent"> > <double name="time">1.0</double> > </lst> > <lst name="org.apache.solr.handler.component.FacetComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.MoreLikeThisComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.HighlightComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.StatsComponent"> > <double name="time">0.0</double> > </lst> > <lst name="org.apache.solr.handler.component.DebugComponent"> > <double name="time">0.0</double> > </lst> > </lst> > </lst> > </lst> > </response> > > I tried to get some docs that contains the coordinates and then created a > retangle around that doc to see it is returned between these ranges. > Don't know if this is the best way to test it, but it's quite easy. > > Best, > Alexandre > > On Thu, Mar 29, 2012 at 2:57 PM, Erick Erickson > <erickerick...@gmail.com>wrote: > >> What are your results? Can you show us the field definition for "local" >> and the results of adding &debugQuery=on? >> >> Because this should work as far as I can tell. >> >> Best >> Erick >> >> On Thu, Mar 29, 2012 at 11:04 AM, Alexandre Rocco <alel...@gmail.com> >> wrote: >> > Hello, >> > >> > I'm trying to perform some queries on a location field on the index. >> > The requirement is to search listings inside a pair of coordinates, like >> a >> > bounding box. >> > >> > Taking a look on the wiki, I noticed that there is the option to use the >> > bbox query but in does not create a retangular shaped box to find the >> docs. >> > Also since the LatLon field is searchable by range, it's possible to use >> a >> > range query to find. >> > >> > I'm trying to search inside a pair of coordinates (the top left corner >> and >> > bottom right corner) and no result is found. >> > >> > The query i'm trying is something like: >> > >> http://localhost:8984/solr/select?wt=json&indent=true&fl=local,*&q=*:*&fq=local:[-23.6674,-46.7314TO >> > -23.6705,-46.7274] >> > >> > Is there any other way to find docs inside a rectangular bounding box? >> > >> > Thanks >> > Alexandre >>
