I don't know if there is something wrong with my syntax but Elastic doesn't reply with an error code.
I have made a query that is like this:
{
"query": {"query_string": {"query": "*"}},
"filter": {
"and": [
{"range":
{"field_1": {"gte": X},
"field_2": {"lte": Y}
}
}
]
}
}
This doen't raise any problem but the results doesn't make sense. There are documents that fulfill the filter criteria but none is shown.
When I perform the query this way:
{
"query": {"query_string": {"query": "*"}},
"filter": {
"and": [
{"range": {"field_1": {"gte": X}}},
{"range": {"field_2": {"lte": Y}}},
]
}
}
I don't see the problem because for some indexes the first query works fine.