[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solr-user
Subject:    Re: Reverse range search
From:       Erick Erickson <erickerickson () gmail ! com>
Date:       2010-10-31 2:09:39
Message-ID: AANLkTinNbuyvfRkgjqr42h5P9barbzusbnUrT12q4FsG () mail ! gmail ! com
[Download RAW message or body]


I wonder if function queries might help you here (be aware that these aren't
my strong point though). See:
http://wiki.apache.org/solr/FunctionQuery

<http://wiki.apache.org/solr/FunctionQuery>Best
Erick

On Thu, Oct 28, 2010 at 5:24 PM, kenf_nc <ken.foster@realestate.com> wrote:

>
> Doing a range search is straightforward. I have a fixed value in a document
> field, I search on [x TO y] and if the fixed value is in the range
> requested
> it gets a hit. But, what if I have data in a document where there is a min
> value and a max value and my query is a fixed value and I want to get a hit
> if the query value is in that range. For example:
>
> Solr Doc1:
> field  min_price:100
> field  max_price:500
>
> Solr Doc2:
> field  min_price:300
> field  max_price:500
>
> and my query is price:250. I could create a query of (min_price:[* TO 250]
> AND max_price:[250 TO *]) and that should work. It should find only doc 1.
> However, if I have several fields like this and complex queries that
> include
> most of those fields, it becomes a very ugly query. Ideally I'd like to do
> something similar to what the spatial contrib guys do where they make
> lat/long a single point. If I had a min/max field, I could call it Price
> (100, 500) or Price (300,500) and just do a query of  Price:250 and Solr
> would see if 250 was in the appropriate range.
>
> Looong question short...Is there something out there already that does
> this?
> Does anyone else do something like this and have some suggestions?
> Thanks,
> Ken
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Reverse-range-search-tp1789135p1789135.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>


[prev in list] [next in list] [prev in thread] [next in thread]