Hello community,
I am very interested in searching over many possible results in a case insensitive way. When I use the text operator over the status field with possible values Closed, In Progress among others, I get positive results even when the casing does not match:
{
"$search": {
"index": "glue-analysis-index",
"text": {
"query": "closed",
"path": "status"
}
}
}
When I try a search with the in operator, I realized that I get results only when the casing matches exactly the one in the records, so for example the following does not work
{
"$search": {
"index": "glue-analysis-index",
"in": {
"value": [
"closed", "in progress"
],
"path": "status"
}
}
}
Since the search is being done case-independently with the text operator I assume the indexing is ok
status: [
{
type: 'stringFacet',
},
{
type: 'string'
},
{
type: 'token'
},
],
So the question is: Is there any way to use the in operator in a case insensitive way? if not, what are the alternatives?