LIKE in Sql Server I'm Using Prefix query in elasticsearch but i have an issue?

Let's say if I search ".5t" I need to get the corresponding document that matches the string that I showed...But I'm getting zero results.

Here is the query
GET indexname/indextype/_search
{
"_source": ["code"],
"query": {
"bool": {
"must": [
{
"prefix": {
"code": {
"value": ".5t"
}
}
}
]
}
}
}

Thanks

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.