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 > > >