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