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 <edwinye...@gmail.com> 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 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, fieldB > > having sum(fieldC) > 1000 > > order by sum(fieldC) asc > > limit 100 > > > Regards, > Edwin > >
