I don't think pivot supports dates at this point. Would probably be good to open an issue to note this feature, as I do think it would be good to have. I would think we could support all the various facet options during pivots (dates, numbers, queries)
On Dec 16, 2010, at 9:22 PM, Adeel Qureshi wrote: > i guess one last call for help .. i am assuming for people who wrote or have > used the pivot faceting .. this should be a yes no question .. are date > fields supported ? > > On Wed, Dec 15, 2010 at 12:58 PM, Adeel Qureshi <adeelmahm...@gmail.com>wrote: > >> Thanks Pankaj - that was useful to know. I havent used the query stuff >> before for facets .. so that was good to know .. but the problem is still >> there because I want the hierarchical counts which is exactly what >> facet.pivot does .. >> >> so e.g. i want to count for fieldC within fieldB and even fieldB within >> fieldA .. that kind of stuff .. for string based fields .. facet.pivot does >> exactly that and does it very well .. but it doesnt seems to work for date >> ranges .. so in this case I want counts to be broken down by fieldA and >> fieldB and then fieldB counts for monthly ranges .. I understand that I >> might be able to use facet.query to construct several queries to get these >> counts .. e.g. *facet.query=fieldA:someValue AND fieldB:someValue AND >> fieldC:[NOW-1YEAR TO NOW]* .. but there could be thousand of possible >> combinations for fieldA and fieldB which will require as many facet.queries >> which I am assuming is not the way to go .. >> >> it might be confusing what I have explained above so the simple question >> still is if there is a way to get date range counts included in facet.pivot >> >> Adeel >> >> >> >> On Tue, Dec 14, 2010 at 10:53 PM, pankaj bhatt <panbh...@gmail.com> wrote: >> >>> Hi Adeel, >>> You can make use of facet.query attribute to make the Faceting work >>> across a range of dates. Here i am using the duration, just replace the >>> field with a field date and Range values as the DATE in SOLR Format. >>> so your query parameter will be like this ( you can pass multiple >>> parameter >>> of "facet.query" name) >>> >>> http//blasdsdfsd/q?=asdfasd&facet.query=itemduration:[0 To >>> 49]&facet.query=itemduration:[50 To 99]&facet.query=itemduration:[100 To >>> 149] >>> >>> Hope, it helps. >>> >>> / Pankaj Bhatt. >>> >>> On Wed, Dec 15, 2010 at 2:01 AM, Adeel Qureshi <adeelmahm...@gmail.com >>>> wrote: >>> >>>> It doesnt seems like pivot facetting works on dates .. I was just >>> curious >>>> if >>>> thats how its supposed to be or I am doing something wrong .. if I >>> include >>>> a >>>> datefield in the pivot list .. i simply dont get any facet results back >>> for >>>> that datefield >>>> >>>> Thanks >>>> Adeel >>>> >>> >> >> -------------------------- Grant Ingersoll http://www.lucidimagination.com/ Search the Lucene ecosystem docs using Solr/Lucene: http://www.lucidimagination.com/search
