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
