Hi All, We have tried both exclude option as well as facet query. Both approach are not giving us the desired results.
I will explain a little further. I have first level facets - Paperback and Ebook, and second level facets include a list of languages like English, French etc.. When user selects 'Paperback', then currently i am getting all the languages of paperback. But "Ebook" is not getting in result. But i can resolve this by using exclude for the first level facet. Now I am facing issue for the second level facet. When the user selects 'Paperback' and 'English', then the query returns only 'Paperback' in first level and 'English' in second level. But I need other languages (which satisfies paperback) also, so that I can show them in second level. We tried with facet.query as well as facet.field options. Please find the query below. http://localhost:8080/solr/collection1/select?q=software%20testing&fq=language%3A(%22English%22)&fq=Binding%3A(%22paperback%22)&facet=true&facet.mincount=1 &facet.field=Language&facet.field=latestArrivals&facet.f ield=Binding&wt=json&indent=true&defType=edismax&json.nl= map&facet.field=language&facet.field=binding. http://localhost:8080/solr/collection1/select?q=software%20testing&fq=language%3A(%22English%22)&fq=Binding%3A(%22paperback%22)&facet=true&facet.mincount=1 &facet.field=Language&facet.field=latestArrivals&facet.f ield=Binding&wt=json&indent=true&defType=edismax&json.nl= map&facet.query=language&facet.query=binding. Please provide your thoughts. Thanks & Regards, Smitha On Wed, Jul 30, 2014 at 8:18 PM, Sujit Pal <sujit....@comcast.net> wrote: > Hi Smitha, > > Have you looked at Facet queries? It allows you to attach Solr queries to > facets. The problem with this is that you will need to know all possible > combinations of language and binding (or make an initial query to find this > information). > > > https://wiki.apache.org/solr/SimpleFacetParameters#facet.query_:_Arbitrary_Query_Faceting > > Another alternative could be to bake in language+binding pairs into a field > in your index and facet on that. > > -sujit > > > > On Wed, Jul 30, 2014 at 7:01 AM, vamshi kiran <mothevamshiki...@gmail.com> > wrote: > > > Hi Alex, > > > > As you said If we exclude language facet field ,it will get all the > > language facets with count right ? > > It Will not filter by binding facet field of type 'paperback' , how can > we > > do this ? > > > > Thanks & Regards, > > Vamshi. > > On Jul 30, 2014 4:11 PM, "Alexandre Rafalovitch" <arafa...@gmail.com> > > wrote: > > > > > I am not sure I fully understood your question, but I would start by > > > looking at Tagging and Excluding first: > > > > > > > > > https://wiki.apache.org/solr/SimpleFacetParameters#Tagging_and_excluding_Filters > > > > > > Regards, > > > Alex. > > > Personal: http://www.outerthoughts.com/ and @arafalov > > > Solr resources and newsletter: http://www.solr-start.com/ and > @solrstart > > > Solr popularizers community: > https://www.linkedin.com/groups?gid=6713853 > > > > > > > > > On Wed, Jul 30, 2014 at 5:07 PM, Smitha Rajiv <smitharaji...@gmail.com > > > > > wrote: > > > > Hi, > > > > > > > > > > > > I need some help on Solr Faceting. > > > > > > > > > > > > How do I facet on two fields at the same time to get combination > facets > > > and > > > > its count? > > > > > > > > I'm using below query to get facets with combination of language and > > its > > > > binding. But now I'm getting only selected facet in facetList of > each > > > > field and its count. For e.g. in language facets the query is > > returning > > > > "English" and its count. Instead I need to get other language facets > > > which > > > > satisfies binding type of paperback > > > > > > > > > > > > > > > > > > > > > > http://localhost:8080/solr/collection1/select?q=software%20testing&fq=language%3A(%22English%22)&fq=Binding%3A(%22paperback%22)&facet=true&facet.mincount=1 > > > > > > > > > > > > > > &facet.field=Language&facet.field=latestArrivals&facet.field=Binding&wt=json&indent=true&defType=edismax& > > > > json.nl=map > > > > > > > > > > > > > > > > Please provide me your inputs. > > > > > > > > > > > > Thanks & Regards, > > > > > > > > Smitha > > > > > >
