Shouldn't td have s2=1 also?  Try this:

      facet.pivot=vi,vk



> On Nov 4, 2015, at 03:23, Mugeesh Husain <muge...@gmail.com> wrote:
> 
> i am facing issue of how to get below response from solr query.
> 
> In my table, i have a two column vi and vk which has below values:
> 
> row1: vi:["ta"] ,vk:["s1"]
> row2: vi:["tb"] ,vk:["s2"]
> row3: vi:["tc"] ,vk:["s0"]
> row4: vi:["td"] ,vk:["s2"]
> row5: vi:["ta"] ,vk:["s1"] 
> row5: vi:["tc"] ,vk:["s0"] and so on.
> 
> I want to facet in below way
> 
> ta-[so=0,s1=2,s2=0]
> tb-[so=0,s1=1,s2=0]
> tc-[so=2,s1=0,s2=0]
> td-[so=0,s1=0,s2=0]
> 
> how i create query which i can get such response ?
> 
> Please suggestion 
> 
> Thanks,
> Mugeesh
> 
> 
> 
> 
> 
> 
> 
> 
> 
> --
> View this message in context: 
> http://lucene.472066.n3.nabble.com/Solr-facet-query-critical-solr-query-response-tp4238135.html
> Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to