lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zheng Lin Edwin Yeo <edwinye...@gmail.com>
Subject Having clause in Faceting
Date Tue, 28 Feb 2017 11:36:39 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message