Hi Morten,
thanks, this is a very good solution.
I also found another solution:Creating a custom ValueSourceParser for
price sorting which consideredthe standard price and the campaign
price.
In my special case I think your approach isn't working, because i
alsoneed result grouping and this cant be combined with field
collapsing.
2011/12/2 Morten Lied Johansen <morte...@ifi.uio.no>:
> On 02. des. 2011 12:21, Mark Schoy wrote:
>
> 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.
