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 <indik...@gmail.com>wrote:
> Hi All,
>
> I am trying to use a stored value in the index and add it to a date
> component as follows
>
> 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)
>
> (order_prep_time is the stored value)
>
> However, when doing so causes the query to return incorrect results. The
> query is part of a if/else query present in the fields (fl) list
>
> _session_available_now_:if(exists(query($sessionAvailableNowQuery)), 100,
> 0)
>
> Is it possible to retrive an integer value from the index and pass it on it
> a date math query ? Is there anything else that needs to be in the query ?
>
> Thanks in advance.
>
