Solr Json APi aggregation specifiy min and max values

Is it possible to get average of amount between two values(min and max specified) in solr JSON Facet API results? Ex: here is the query i need to apply in Solr SELECT STATE, AVG(AMOUNT) from Table group by STATE having AVG(AMOUNT) > 3000 AND AVG(AMOUNT) < 5000 currently i am getting avg amounts

Re: Solr Json APi aggregation specifiy min and max values

Thank you very much for the quick response - will try - looks like need to run solr as a solrCloud -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Json-APi-aggregation-specifiy-min-and-max-values-tp4324342p4324381.html Sent from the Solr - User mailing list archive at N

Re: Simple sql query with where clause doesn't work

Did you find answer I getting same error when I use text instead of number in Where clause - Please let me know. -- View this message in context: http://lucene.472066.n3.nabble.com/Simple-sql-query-with-where-clause-doesn-t-work-tp4324498p4328991.html Sent from the Solr - User mailing list arch