Re: SOLR to pivot on date range query

2015-08-18 Thread Erick Erickson
>> >> Thanks, >> Lewin >> >> -Original Message- >> From: Yonik Seeley [mailto:ysee...@gmail.com] >> Sent: Monday, August 17, 2015 12:26 PM >> To: solr-user@lucene.apache.org >> Subject: Re: SOLR to pivot on date range query >> >

Re: SOLR to pivot on date range query

2015-08-18 Thread Upayavira
hat in my original mail. > > Thanks, > Lewin > > -Original Message- > From: Yonik Seeley [mailto:ysee...@gmail.com] > Sent: Monday, August 17, 2015 12:26 PM > To: solr-user@lucene.apache.org > Subject: Re: SOLR to pivot on date range query > > The JSON Facet API

RE: SOLR to pivot on date range query

2015-08-17 Thread Lewin Joy (TMS)
-Original Message- From: Yonik Seeley [mailto:ysee...@gmail.com] Sent: Monday, August 17, 2015 12:26 PM To: solr-user@lucene.apache.org Subject: Re: SOLR to pivot on date range query The JSON Facet API can embed any type of facet within any other type: http://yonik.com/json-facet-api

Re: SOLR to pivot on date range query

2015-08-17 Thread Yonik Seeley
The JSON Facet API can embed any type of facet within any other type: http://yonik.com/json-facet-api/ json.facet={ dates : { type : range, field : entryDate, start : "2001-...", // use full solr date format end : "2015...", gap : "+1MONTH", facet : { type:terms,

SOLR to pivot on date range query

2015-08-17 Thread Lewin Joy (TMS)
Hi, I have data that is coming in everyday. I need to query the index for a time range and give the facet counts ordered by different months. For this, I just have a solr date field, entryDate which captures the time. How do I make this query? I need the results like below. Jan-2015 (2000)