Re: Date Range Query + Fields

2008-03-18 Thread Chris Hostetter
: For instance: A document with a start_date of 1/1/08 and an end_date : of 3/1/08 should still match for a search of the range 2/1/08 to : 2/2/08. if I'm understanding you correctly, what you want is something like... startDate:[* TO NOW+30DAY] AND endDate:[NOW TO *] ..that should give you

Re: Date Range Query + Fields

2008-03-17 Thread Shalin Shekhar Mangar
Hi Nathan, We had a similiar problem but with a numeric field and we had solved it by keeping both start and end range as one multivalued field. Then your first query will get you the desired results. On Tue, Mar 18, 2008 at 2:52 AM, Nathan Woodhull <[EMAIL PROTECTED]> wrote: > Actually, it doesn

Re: Date Range Query + Fields

2008-03-17 Thread Nathan Woodhull
Actually, it doesn't. This does not take care of documents that extend beyond the bounds of the current 30 day window... which are relevant even though both the start and end are not within the range. For instance: A document with a start_date of 1/1/08 and an end_date of 3/1/08 should still match

Re: Date Range Query + Fields

2008-03-17 Thread Nathan Woodhull
Nevermind, this is actually easy: StartDate: [NOW TO NOW+30DAY] AND EndDate: [NOW TO NOW+30DAY] -Nathan On 3/17/08, Nathan Woodhull <[EMAIL PROTECTED]> wrote: > Hi, > > I'm working on an application where the documents in the solr index > might only be relevant to users within a date range. We

Date Range Query + Fields

2008-03-17 Thread Nathan Woodhull
Hi, I'm working on an application where the documents in the solr index might only be relevant to users within a date range. We are storing a start_date and an end_date in the index for each document that defines the range for which the document is relevant. These date ranges in the document might