[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solr-user
Subject:    Re: Stored values and date math query
From:       Erick Erickson <erickerickson () gmail ! com>
Date:       2013-02-28 13:15:37
Message-ID: CAN4YXvdpeCNBo3DrgdkSW6pwSsDzqvW7A2OckeMw2xGFSsqkfQ () mail ! gmail ! com
[Download RAW message or body]


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 <indika85@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.
>


[prev in list] [next in list] [prev in thread] [next in thread]