Re: Best practise to automatically change a field value for a specific period of time

2011-12-02 Thread Mark Schoy
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

Re: Best practise to automatically change a field value for a specific period of time

2011-12-02 Thread Mathias Hodler
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 c

Re: Best practise to automatically change a field value for a specific period of time

2011-12-02 Thread Morten Lied Johansen
On 02. des. 2011 12:21, Mark Schoy wrote: Hi, I have an solr index for an online shop with a field "price" which contains the standard price of a product. But in the database, the shop owner can specify a period of time with an alternative price. For example: standard price is $20.00, but 12/24

Re: Best practise to automatically change a field value for a specific period of time

2011-12-02 Thread Michael Kuhlmann
Hi Mark, I'm sure you can manage this using function queries somehow, but this is rather complicated, esp. if you both want to return the price and sort on it. I'd rather update the index as soon as a campaign starts or ends. At least that's how we did it when I worked for online shops. Norm

Re: Best practise to automatically change a field value for a specific period of time

2011-12-02 Thread darren
Solr doesn't support these kind of business rules inside of it. Not intended to. Thusly, you will have to manage them externally. What's unstable about a cronjob? You will have to run your business rules externally, then apply the necessary field updates to the documents in Solr, ensuring the do

Best practise to automatically change a field value for a specific period of time

2011-12-02 Thread Mark Schoy
Hi, I have an solr index for an online shop with a field "price" which contains the standard price of a product. But in the database, the shop owner can specify a period of time with an alternative price. For example: standard price is $20.00, but 12/24/11 08:00am to 12/26/11 11:59pm = $12.59 Of