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 furkankamaci@gmail.com
 designates 209.85.214.174 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1397336896517-4130807.post@n3.nabble.com>
References: <1397334799453-4130802.post@n3.nabble.com>
	<5E9FE50890864306B6583EEED7D8609A@JackKrupansky14>
	<1397336896517-4130807.post@n3.nabble.com>
Date: Sun, 13 Apr 2014 02:08:50 +0300
Message-ID: 
 <CAHsXEHVMSHj+cFmy7=T_t5DgGzWWPOVpODnRkopfF3W_MMjL=g@mail.gmail.com>
Subject: Re: Fetching document by comparing date to today date
From: Furkan KAMACI <furkankamaci@gmail.com>
To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org>
Content-Type: multipart/alternative; boundary=089e0158a8368cbfa904f6e08871

--089e0158a8368cbfa904f6e08871
Content-Type: text/plain; charset=ISO-8859-1

Hi Darniz;

Why don't you filter your documents that has a date until TODAY and then
sort them by date and finally get only 1 document with rows=1 ?

Thanks;
Furkan KAMACI


2014-04-13 0:08 GMT+03:00 Darniz <rnizamuddin@edmunds.com>:

> Thanks for the quick answer i was able to solve my problem with the
> addition
> of two new fields and if todays date is april14 my query is
>
> (liveStartDate:[* TO 2014-04-14T00:00:00Z] AND
> liveEndDate:[2014-04-14T00:00:00Z TO *])
>
> and its fetches me the correct document
>
> guess my initial question does solr provide out of the box functionality if
> i have the below three documents set,  how can i get only doc2 if i assume
> todays date is 14-APRIL-2014
>
> for simplicity i gave the liveDate as dates beginning at the start of each
> month but in real life these dates can be anything.
> <doc1 liveDate=1-MAR-2014>
> <doc2 liveDate=1-APR-2014>
> <doc3 liveDate=1-MAY-2014>
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Fetching-document-by-comparing-date-to-today-date-tp4130802p4130807.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>

--089e0158a8368cbfa904f6e08871--