Filter with aggregation not working

Elastic Stack Elasticsearch
1

Hi All,
below query not working please help on this:

{
    "query" : {
    "bool": {
    "must": [
         {"term": {"field1": "value1"}},
         {"wildcard": {"field2": "*value2*"}}
            ],
    "must_not": [ ],
    "should": [ ]
      }
    },
    "aggs" : {
        "genres": {
            "terms" : { "field" : "field3"  }
        }
    }
}

in result, the bucket shows empty

but its able to get with below

{
    "query" : {
    "bool": {
    "must": [
         {"term": {"field1": "value1"}},
         {"wildcard": {"field2": "*value2*"}}
            ],
    "must_not": [ ],
    "should": [ ]
      }
    },
    "aggs" : {
        "genres": {
            "terms" : { "field" : "**field2**"  }
        }
    }
}

and

{
    "query" : {
    "bool": {
    "must": [
         {"term": {"field1": "value1"}},
         {"wildcard": {"field2": "*value2*"}}
            ],
    "must_not": [ ],
    "should": [ ]
      }
    },
    "aggs" : {
        "genres": {
            "terms" : { "field" : "**field1**"  }
        }
    }
}
2

Hi all,

any one please help on this

3

Does field3 have doc values enabled? And does this field have values for the documents that match your query?

4

Hi jpountz,
Thanks for reply.

doc values not enabled for the field3,

its work with
{
"aggs" : {
"genres": {
"terms" : { "field" : "field1" }
}
}
}

i don't know why its not work with bool query .