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?
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.
This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.