Hi Morten, thanks, this is a very good solution.
I also found another solution: Creating a custom ValueSourceParser for price sorting which considered the standard price and the campaign price. In my special case I think your approach isn't working, because i also need result grouping and this cant be combined with field collapsing. 2011/12/2 Morten Lied Johansen <morte...@ifi.uio.no>: > > This is a problem that can be solved with grouping. > http://wiki.apache.org/solr/FieldCollapsing > > For each possible price on a product, you index a document with the dates > and the price. In your query, you group on the product, and apply a > date-filter, and the price you see for each product will be from the top > document within the given dates. > > You can also sort by price. If you have multiple overlapping campaigns, you > might need to pay attention to which one you want to take precedence, as > your sorting will determine which document gets shown. > > -- > Morten > We all live in a yellow subroutine.
