Re: Stored values and date math query

2013-03-04 Thread Indika Tantrigoda
Thanks for the insights to the query Hoss. I am going to try out the methods you highlighted. Thanks, Indika On 3 March 2013 01:19, Chris Hostetter wrote: > > : sessionAvailableNowQuery = {!edismax}(start_time:[* TO > : 1970-01-01T12:37:030Z] AND end_time:[1970-01-01T12:37:030Z + > : (_val_:ord

Re: Stored values and date math query

2013-03-02 Thread Chris Hostetter
: sessionAvailableNowQuery = {!edismax}(start_time:[* TO : 1970-01-01T12:37:030Z] AND end_time:[1970-01-01T12:37:030Z + : (_val_:order_prep_time)MINUTES TO *] AND consumers:[1 TO *] AND : session_time_range_available:true) you can't embed the valuef of a field inside a query string like that (the

Re: Stored values and date math query

2013-03-01 Thread Indika Tantrigoda
Hi Erick, Thanks for the response. The the terms are indexed. I will need to dig deeper and see there the issue is, it might be a correct syntax but I may be using it incorrectly. In the meantime I have added a new column that is end_time - order_prep_time and validate if a session is available ag

Re: Stored values and date math query

2013-02-28 Thread Erick Erickson
Just to check, your order_prep_time is _indexed_ too, right? It's a bit confusing but anything you use in your function queries will be from indexed terms, not stored ones Best Erick On Tue, Feb 26, 2013 at 4:05 PM, Indika Tantrigoda wrote: > Hi All, > > I am trying to use a stored value in the