Re: Reverse range search

[Jan Høydahl / Cominvent <ja...@cominvent.com>]

Hi,

I think I have seen a comment on the list from someone with the same need a few months ago.
He planned to make a new fieldType to support this, e.g. MinMaxRangeFieldType which would
be a polyField type holding both a min and max value, and then you could query it
q=myminmaxfield:123

I did not find it as a Jira issue however, but I can see how it would be useful for a lot of usecases. Perhaps you can create a Jira issue for it and supply a patch? :)

--
Jan Høydahl, search solution architect
Cominvent AS - www.cominvent.com

On 28. okt. 2010, at 23.24, kenf_nc 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.