I am trying to get some results from elasticsearch using the below query. But it gives no result. I have data which should come in the result. If i run any of the mentioned wildcard then it gives result but together it gives no result.
{
"query": {
"bool": {
"must": [
{
"wildcard": {
"firstname": "*nne*"
}
},
{
"wildcard": {
"lastname": "*ste*"
}
}
]
}
}
}
It should return something like Anne rooster for example. Anyone knows if we can use multiple wildcards using AND operator? If there are any example that will be helpful. I have tried query_string as well but again with no result.