In response to myself, The problem occurs because the date ranges are inclusive. I can fix this by making facet.date.gap = +1MONTH-1SECOND, but is there a way to specify that the upper bound is exclusive, rather than inclusive?
Liam On Wed, 2010-02-24 at 16:54 +1100, Liam O'Boyle wrote: > Afternoon, > > I have a strange problem occurring with my date faceting. I seem to > have more results in my facets than in my actual result set. > > The query filters by date to show results for one year, i.e. > ib_date:[2000-01-01T00:00:00Z TO 2000-12-31T23:59:59Z], then uses date > faceting to break up the dates by month, using the following > parameters > > facet=true > facet.date=ib_date > facet.date.start=2000-01-01T00:00:00Z > facet.date.end=2000-12-31T23:59:59Z > facet.date.gap=+1MONTH > > However, I end up with more numbers in the facets than there are > documents in the response, including facets for dates that aren't > matched. See below for a summary of the results pulled out > through /solr/select. > > <result name="response" numFound="4" start="0"> > - > <doc> > <date name="ib_date">2000-12-01T00:00:00Z</date> > </doc> > − > <doc> > <date name="ib_date">2000-08-01T00:00:00Z</date> > </doc> > − > <doc> > <date name="ib_date">2000-06-01T00:00:00Z</date> > </doc> > − > <doc> > <date name="ib_date">2000-11-01T00:00:00Z</date> > </doc> > </result> > − > <lst name="facet_counts"> > <lst name="facet_queries"/> > <lst name="facet_fields"/> > − > <lst name="facet_dates"> > − > <lst name="ib_date"> > <int name="2000-01-01T00:00:00Z">0</int> > <int name="2000-02-01T00:00:00Z">0</int> > <int name="2000-03-01T00:00:00Z">0</int> > <int name="2000-04-01T00:00:00Z">0</int> > <int name="2000-05-01T00:00:00Z">1</int> > <int name="2000-06-01T00:00:00Z">1</int> > <int name="2000-07-01T00:00:00Z">1</int> > <int name="2000-08-01T00:00:00Z">1</int> > <int name="2000-09-01T00:00:00Z">0</int> > <int name="2000-10-01T00:00:00Z">1</int> > <int name="2000-11-01T00:00:00Z">2</int> > <int name="2000-12-01T00:00:00Z">1</int> > <str name="gap">+1MONTH</str> > <date name="end">2001-01-01T00:00:00Z</date> > </lst> > </lst> > </lst> > > Is there something I'm missing here? > > Thanks, > Liam
