[
https://issues.apache.org/jira/browse/SOLR-9603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15547369#comment-15547369
]
jefferyyuan commented on SOLR-9603:
-----------------------------------
Original link:
http://lucene.472066.n3.nabble.com/Facet-Stats-MinCount-How-to-use-mincount-filter-when-use-facet-stats-td4299367.html
https://issues.apache.org/jira/browse/SOLR-9602
> Facet bucket filters
> --------------------
>
> Key: SOLR-9603
> URL: https://issues.apache.org/jira/browse/SOLR-9603
> Project: Solr
> Issue Type: New Feature
> Security Level: Public(Default Security Level. Issues are Public)
> Components: Facet Module
> Reporter: Yonik Seeley
>
> "filter" may be a bit of an overloaded term, but it would be nice to be able
> to filter facet buckets by additional things, like the metrics that are
> calculated per bucket.
> This is like the HAVING clause in SQL.
> Example of a facet that would group by author, find the average review rating
> for that author, and filter out authors (buckets) with less than a 3.5
> average.
>
> {code}
> reviews : {
> type : terms,
> field: author,
> sort: "x desc",
> having: "x >= 3.5",
> facet : {
> x : avg(rating)
> }
> }
> {code}
>
> This functionality would also be useful for "pushing down" more calculations
> to the endpoints for streaming expressions / SQL.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
