Hi Otis,
Absolutely, I missed that nugget. I didn't think of using prefix
filters/queries. This works really well with how we had already stored
dates in a YYYYMMDD string. Thanks for pointing me in the right direction.
Tricia
Otis Gospodnetic wrote:
Tricia,
I think you might have missed the key nugget at the bottom of
http://wiki.apache.org/jakarta-lucene/DateRangeQueries
Otis
--
Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch
----- Original Message ----
From: Tricia Williams <[EMAIL PROTECTED]>
To: solr-user@lucene.apache.org
Sent: Wednesday, December 10, 2008 12:12:11 PM
Subject: Dates in Solr
Hi All,
I'm curious about what people have done with dates.
We Require:
1. multiple granularities to query and facet on: by year, by
year/month, by year/month/day
2. sortability: sort/order by date
3. time typically isn't important to us
4. some of these items don't have a day or month associated with them
5. possibly consider seasonal like publications with "FALL" as a date
This is the bulk of what I found documented in the mailing list and wiki:
* http://www.nabble.com/dates---times-td10417533.html#a10421952
* http://wiki.apache.org/jakarta-lucene/LargeScaleDateRangeProcessing
*
http://wiki.apache.org/solr/SimpleFacetParameters#head-068dc96b0dac1cfc7264fe85528d7df5bf391acd
o
http://lucene.apache.org/solr/api/org/apache/solr/util/DateMathParser.html
o
http://lucene.apache.org/solr/api/org/apache/solr/schema/DateField.html
* any queries on those fields (typically range queries) should use
either the Complete ISO 8601 Date syntax that field supports, or
the DateMath?
Syntax
to get relative dates
This is great and valuable. I would like to be able to use the existing
functionality but I'm not sure how I can use the DateField to specify a year
without a time (what I guess would actually be a range of time) for a document.
Any ideas?
Tricia