You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by cjkadakia <cj...@sonicbids.com> on 2010/02/19 01:58:23 UTC
Range Searches in Collections
Hi, I'm trying to do a search on a range of floats that are part of my solr
schema. Basically we have a collection of "fees" that are associated with
each document in our index.
The query I tried was:
q=fees:[3 TO 10]
This should return me documents with Fee values between 3 and 10
inclusively, which it does. However, I need it to check for ALL items in
this collection, not just one that satisfies it. Currently, this is
returning me documents with fee values above 10 and below 3 as long as it
contains at least one other within.
Any suggestions on how to accomplish this?
--
View this message in context: http://old.nabble.com/Range-Searches-in-Collections-tp27648470p27648470.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Range Searches in Collections
Posted by cjkadakia <cj...@sonicbids.com>.
Unfortunately the number of fees is unknown so we couldn't add the fields
into the solr schema until runtime. The work-around we did was create an
additional column in the view I'm pulling from for the index to determine
each record's minimum "fee" and throw that into the column. A total hack,
but now I can simply sort on the "minFee" and problem (hackingly) solved! :)
Otis Gospodnetic wrote:
>
> Hm, yes, it sounds like your "fees" field has multiple values/tokens, one
> for each fee. That's full-text search for you. :)
> How about having multiple fee fields, each with just one fee value?
>
> Otis
> ----
> Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch
> Hadoop ecosystem search :: http://search-hadoop.com/
>
>
>
>
> ________________________________
> From: cjkadakia <cj...@sonicbids.com>
> To: solr-user@lucene.apache.org
> Sent: Thu, February 18, 2010 7:58:23 PM
> Subject: Range Searches in Collections
>
>
> Hi, I'm trying to do a search on a range of floats that are part of my
> solr
> schema. Basically we have a collection of "fees" that are associated with
> each document in our index.
>
> The query I tried was:
>
> q=fees:[3 TO 10]
>
> This should return me documents with Fee values between 3 and 10
> inclusively, which it does. However, I need it to check for ALL items in
> this collection, not just one that satisfies it. Currently, this is
> returning me documents with fee values above 10 and below 3 as long as it
> contains at least one other within.
>
> Any suggestions on how to accomplish this?
> --
> View this message in context:
> http://old.nabble.com/Range-Searches-in-Collections-tp27648470p27648470.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
--
View this message in context: http://old.nabble.com/Range-Searches-in-Collections-tp27648470p27653341.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Range Searches in Collections
Posted by Otis Gospodnetic <ot...@yahoo.com>.
Hm, yes, it sounds like your "fees" field has multiple values/tokens, one for each fee. That's full-text search for you. :)
How about having multiple fee fields, each with just one fee value?
Otis
----
Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch
Hadoop ecosystem search :: http://search-hadoop.com/
________________________________
From: cjkadakia <cj...@sonicbids.com>
To: solr-user@lucene.apache.org
Sent: Thu, February 18, 2010 7:58:23 PM
Subject: Range Searches in Collections
Hi, I'm trying to do a search on a range of floats that are part of my solr
schema. Basically we have a collection of "fees" that are associated with
each document in our index.
The query I tried was:
q=fees:[3 TO 10]
This should return me documents with Fee values between 3 and 10
inclusively, which it does. However, I need it to check for ALL items in
this collection, not just one that satisfies it. Currently, this is
returning me documents with fee values above 10 and below 3 as long as it
contains at least one other within.
Any suggestions on how to accomplish this?
--
View this message in context: http://old.nabble.com/Range-Searches-in-Collections-tp27648470p27648470.html
Sent from the Solr - User mailing list archive at Nabble.com.