Re: query range in multivalued date field

2011-01-27 Thread Erick Erickson
Range queries work on multivalued fields. I suspect the date math
conversion is fooling you. For instance,NOW/HOUR first rounds down to
the current hour, *then* subtracts one hour.

If you attach &debugQuery=on (or check the debug checkbox
in the admin full search page), you'll see the exact results of
the conversion, that may help.

Best
Erick

On Thu, Jan 27, 2011 at 5:15 AM, ramzesua  wrote:

>
> hi all. My query range for multivalued date field work incorrect.
> My schema. There is field "requestDate" that have multivalued attr.:
> 
>required="true" />
>   
>   
>default="0" multiValued="true" />
>multiValued="true" />
>  
>
> Some data from the index:
>
> 
>  2.0
>  sale
>  11
>  sale
>  
> name="requestDate">2011-01-26T08:18:35Z2011-01-27T01:31:28Z
>  
>  
>  3.0
>  coldpop
>  111
>  cold pop
>  
> name="requestDate">2011-01-27T01:30:01Z2011-01-27T01:32:01Z2011-01-27T01:32:18Z
>  
>
> I try to search some docs where date is in some range, for example,
> http://localhost:8983/request/select?q=requestDate:[NOW/HOUR-1HOUR TO
> NOW/HOUR]
> There are no result. After some analyzing, I saw, that this range works
> only
> for first item in the requestDate field, but don't filtered for another
> items. Where is my mistake? Or SOLR can't filtered multivalued date fields?
> Thanks
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/query-range-in-multivalued-date-field-tp2361292p2361292.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>


query range in multivalued date field

2011-01-27 Thread ramzesua

hi all. My query range for multivalued date field work incorrect.
My schema. There is field "requestDate" that have multivalued attr.:
   
   
   
   
   
   
 

Some data from the index:

 
  2.0 
  sale 
  11 
  sale 
  2011-01-26T08:18:35Z2011-01-27T01:31:28Z
 
  
  
  3.0 
  coldpop 
  111 
  cold pop 
  2011-01-27T01:30:01Z2011-01-27T01:32:01Z2011-01-27T01:32:18Z
 
  

I try to search some docs where date is in some range, for example,
http://localhost:8983/request/select?q=requestDate:[NOW/HOUR-1HOUR TO
NOW/HOUR]
There are no result. After some analyzing, I saw, that this range works only
for first item in the requestDate field, but don't filtered for another
items. Where is my mistake? Or SOLR can't filtered multivalued date fields?
Thanks
-- 
View this message in context: 
http://lucene.472066.n3.nabble.com/query-range-in-multivalued-date-field-tp2361292p2361292.html
Sent from the Solr - User mailing list archive at Nabble.com.