{
"query": {
"query_string": {
"query": "(FILE_ID:x OR FILE_ID:y OR ....) AND (SITE_ID:z)"
}
}
}
POST index_name/type_name/_delete_by_query
{
"query": {
"bool": {
"must": [
{"term": {"SITE_ID": "z"}}
],
"should": [
{"term": {"FILE_ID": "x"}},
{"term": {"FILE_ID": "y"}},
...
],
"minimum_should_match": 1
}
}
}