ElasticSearch aggregation: exclude one filter per aggregation

Question

I want to filter out documents whose field 'A' is equal to 'a', and I want to facet the field 'A' at the same time, excluding of course the previous filter. I know that you can put the filter 'outside' the query in order to get the facets without that filter applied, like:

ElasticSearch

{
   "query : { "match_all" : { } },  
   "filter" : { "term : { "A" : "a" } },
   "facets" : { 
      "A" : { "terms" : { "field" : "A" } }  //this should exclude the filter A:a
   }
}

SOLR

&q=:*:*
&fq={!tag=Aa}A:a
&facet=true&facet.field={!ex=Aa}A

This is very nice, but what happens if i have multiple filters and facets that each one should exclude each other? Example:

filter=A:a
filter=B:b
filter=C:c

facet={exclude filter A:a}A
facet={exclude filter B:b}B
facet={exclude filter C:c}C

That is, for facet A I want to keep all filters except A:a, for facet B all except B:b, and so on. The most obvious way would be to do n queries (one per each of the n facets), but I'd like to stay away from that.

Yes, I had to move all filters to "post filter" ( elasticsearch.org/guide/en/elasticsearch/reference/current/… ) and build a filter for each aggregation excluding unnecessary filter ( elasticsearch.org/guide/en/elasticsearch/reference/current/… ). — Alexey Kosov
I seem to have worked around it by aggregating scoped to global and then selecting the appropriate filters for each aggregation. — Mauricio Scheffer

Lionel Sengkouvanh Lionel Sengkouvanh · Accepted Answer · 2014-11-13T18:20:02

The global scope provides access to every document, you can then add the same filters you used for the main query.

I gave an example with global scope in this related topic

Could you give any feedback about performance issue with post_filter ?

ElasticSearch aggregation: exclude one filter per aggregation

1 Answers