Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (nike.apache.org: domain of arunrangarajan@gmail.com
 designates 209.85.212.172 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAN4YXvcHLAxN4-TiFzDmNyZpkRVqUMjBaVRgnqb2kWR574NjCw@mail.gmail.com>
References: 
 <CALfwwiTj7u=iUbPURwQ-o8qYitkdQLux6qE41p1++JaiU2ogWA@mail.gmail.com>
 <CAN4YXvcHLAxN4-TiFzDmNyZpkRVqUMjBaVRgnqb2kWR574NjCw@mail.gmail.com>
From: Arun Rangarajan <arunrangarajan@gmail.com>
Date: Tue, 30 Apr 2013 12:22:20 -0700
Message-ID: 
 <CAOnbPhRfgicO5D2+pgMU2Cx0s5i3wA11JwKQcD0G+N5PvmK5eA@mail.gmail.com>
Subject: Re: Solr Range Queries with Field value
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=001a11c21a60be8b9104db98ec10

--001a11c21a60be8b9104db98ec10
Content-Type: text/plain; charset=ISO-8859-1

Erick,

I believe Indika wants to do this SQL WHERE clause in Solr:
WHERE start_time_utc_epoch >= '1970-01-01T00:00:00Z' AND start_time_utc_epoch
<= merchant_end_of_day_in_utc_epoch


On Tue, Apr 30, 2013 at 11:49 AM, Erick Erickson <erickerickson@gmail.com>wrote:

> Could you define your use-case in some more detail? On the
> surface, this query doesn't really make a lot of sense. How
> would merchant_end_of_day_in_utc_epoch be determined?
> Presumably there are zillions of values across your index for
> this value, depending on the document. Which one should be
> used?
>
> Best
> Erick
>
> On Mon, Apr 29, 2013 at 8:34 PM, Indika Tantrigoda <indika85@gmail.com>
> wrote:
> > Hi All,
> >
> > I'd like to know if its possible to use a field value in a Solr range
> query
> > ? Something similar to start_time_utc_epoch:[1970-01-01T00:00:00Z TO
> > merchant_end_of_day_in_utc_epoch])
> >
> > merchant_end_of_day_in_utc_epoch is an indexed field.
> >
> > I am using Solr 4.
> >
> > Thanks,
> > Indika
>

--001a11c21a60be8b9104db98ec10--