I am trying to combine a "filter" with a "bool"/"should" inside a "must". The following query is automatically generated by an application (hence the nesting). How must the query look like to have an AND condition between the wildcard condition and the filter statement?
"query":{
"bool":{
"filter": {
"bool": {
"must": [],
"must_not": [],
"should": [],
"filter": {
"bool": {
"should": [
{
"wildcard": {
"attachment.content_type.keyword": "video/*"
}
}
],
"must": [],
"must_not": [],
"filter": [
{
"terms": {
"status.keyword": [
"xxx"
]
}
}
]
}
}
}
}
}
}