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.
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.