I’m trying to sort my users by the name (case insensitive) but can’t get it working.
Here is a simple cloud code:
var teamUserQuery = new Parse.Query('TeamMember')
teamUserQuery.ascending('fullName')
const teamRet = await teamUserQuery.find({ sessionToken: sessionToken, caseInsensitive:true })
I’m still getting capital letters and small letters sorted separately. It’s not working.
When I try to explain query I’m getting an error (it works without caseInsensitive:true):
teamRet is not iterable
I’ve created index on TeamMember :
db.TeamMember.createIndex( { fullName: 1 }, { collation: { locale: ‘en_US’, strength: 2 } } );
Still wrong order, but when I try to query the db with mongodb compass the order works well when using {locale:‘en_US’} or {locale:‘en’}
What am I doing wrong?