case insensitive in operator in Atlas search

Daniel_Oriz-Yepes · 2024-10-02T07:35:52.404Z

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?

Erik_Hatcher · 2024-10-02T13:22:05.819Z

The token type has a normalizer that can be set to lowercase for case-insensitive matching.