I've tested this before, even re-tried now to make sure I wasn't making a mistake, but if terms with an array of values is under a must filter, it doesn't match anything at all. Any ideas?
Your use of terminology is confusing.
Query clauses operate on values in individual documents in individual shards.
Aggregations are summaries of many documents held on many shards.
The former filters the set of documents summarised by the latter.
That sounds like it would be useful. As trimmed-down as possible please (so only has the fields of interest and the minimum number of docs).
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.