[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solr-user
Subject:    Having clause in Faceting
From:       Zheng Lin Edwin Yeo <edwinyeozl () gmail ! com>
Date:       2017-02-28 11:36:39
Message-ID: CAF2DzVXEQrXYB7rN=yFo6iW2pYdCxKEgD8xY9Qu20F4xsriE_g () mail ! gmail ! com
[Download RAW message or body]


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


[prev in list] [next in list] [prev in thread] [next in thread]