You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Yonik Seeley (JIRA)" <ji...@apache.org> on 2016/10/05 01:26:20 UTC

[jira] [Created] (SOLR-9603) Facet bucket filters

Yonik Seeley created SOLR-9603:
----------------------------------

             Summary: 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org