Hello. I'm doing the following query to search some itens:
{
"filtered" : {
"query" : {
"match" : {
"name_db" : {
"query" : "Human",
"type" : "boolean"
}
}
},
"filter" : {
"terms" : {
"cat" : [ "B8E" ],
"execution" : "bool"
}
}
}
}
See that "cat" field? When it's something like "B8E" there are no results (even though it should), while when it's something like "320" the results are correct. What could be wrong? Why mixing letters and number would be a problem?
EDIT: It's not only when mixing letters and numbers, there are also no results and "cat" has only letters. For instance: BFD. It only works when cat is only numbers.
Thanks in advance.
PS: I'm new to elasticsearch