MongoDB.live, free & fully virtual. Register Now MongoDB.live, free & fully virtual. Register Now

Do wildcard indices support collation?

I’m trying to do a case insensitive sort of a nested dynamic field using a wild card index.
I set the collation strength to various values but I’m not getting a case insensitive sort order.
The index was created and did not produce an error message.

How can I get a case insensitive sort?

Thanks

Hi, I solved my issue. I am using the mongoid ruby driver, and I had to add the collation to my query to choose the collation defined for the index. For example .collation(locale: "en") and it works.

3 Likes

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