I do not think this is possible. You will probably want to handle
this logic on your side during indexing. Index the document with the
fist price, then as that price expires, update the document with the
new price.
Thanks,
Matt Weber
eSr Technologies
http://www.esr-technologies.com
On May 6, 2009, at 4:32 AM, Andrew Ingram wrote:
Hi everyone,
I'm working on the search schema for ecommerce products and I'm having
an issue with the prices.
Basically, a product has two price values and a date, the product
effectively has one price before the date and the other one after.
This poses no problem for the site itself since I can use conditional
logic, but I have no idea how to approach this with regards to solr
queries.
The price of a product is used for both faceting and sorting and
should use whichever price is active at the time of the query. Is
there any way to do define a field whose value is a simple algorithm
operating on the value of other fields?
I'm quite happy to use a custom field type if necessary, though I'm
not sure if what I want is even possible and I don't really know where
to begin.
Any help would be appreciated
Regards,
Andrew Ingram