Did you look at Gilt's presentation from a while ago: http://www.slideshare.net/trenaman/personalized-search-on-the-largest-flash-sale-site-in-america
Slides 33 on might be most relevant. Regards, Alex. ---- Solr Analyzers, Tokenizers, Filters, URPs and even a newsletter: http://www.solr-start.com/ On 21 May 2015 at 22:58, alexw <aw...@crossview.com> wrote: > Hi, > > I have an unique requirement to facet on product prices based on date > constraints, for which I have been thinking for a solution for a couple of > days now, but to no avail. The details are as follows: > > 1. Each product can have multiple prices, each price has a start-date and an > end-date. > 2. At search time, we need to facet on price ranges ($0 - $5, $5-$20, > $20-$50...) > 3. When faceting, a date is first determined. It can be either the current > system date or a future date (call it date X) > 4. For each product, the price to be used for faceting has to meet the > following condition: start-date < date X, and date X < end-date, in other > words, date X has to fall within start-date and end-date. > 5. My Solr version: 3.5 > > Hopefully I explained the requirement clearly. I have tried single price > field with multivalue and each price value has startdate and enddate > appended. I also tried one field per price with the field name containing > both startdate and enddate. Neither approach seems to work. Can someone > please shed some light as to how the index should be designed and what the > facet query should look like? > > Thanks in advance for your help! > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Price-Range-Faceting-Based-on-Date-Constraints-tp4206817.html > Sent from the Solr - User mailing list archive at Nabble.com.