Re: Having clause in Faceting

2017-03-01 Thread Zheng Lin Edwin Yeo
Hi, Is it possible to do this Having Clause in Solr Facet or JSON Facet query? Regards, Edwin On 28 February 2017 at 19:36, Zheng Lin Edwin Yeo wrote: > Hi, > > Would like to check, how can we put the having clause (having sum(fieldC) > > 1000) in the following example in Solr Facet or JSON Fa

Having clause in Faceting

2017-02-28 Thread Zheng Lin Edwin Yeo
Hi, Would like to check, how can we put the having clause (having sum(fieldC) > 1000) in the following example in Solr Facet or JSON Facet query? I'm using Solr 6.4.1. select fieldA, fieldB, count(*), sum(fieldC), avg(fieldY) from collection1 where fieldC = 'term1 term2' group by fieldA, fiel