Rocket.chat: [Improvment] Sorting in private message list

[janrudolph]

Description:

If you sort your private messages alphabetically, the sorting is not correct. Capital letters are ranked higher, as the following example shows.

Server Setup Information:

• Version of Rocket.Chat Server: 0.62.1

Steps to Reproduce:

1. Create two users: aabc and Abc
2. Start private conversations with them
3. Have a look in the left sidebar

Expected behavior:

Ranking:

• aabc
• Abc

Actual behavior:

Ranking:

• Abc
• aabc

Real world example in open.rocket.chat:

[JSzaszvari]

You don't assign issues in GitHub. Just let people know you are working on it and then submit a PR.

[theorenck]

Hi @vishwakperera we gladly accept a PR for this one. Just check with @karlprieb if you need any help.

[JoseRenan]

I was seeing the code which sorts the DM list and discovered that it is sorted by mongo. When I searched about it, I discovered that mongo doesn't currently support case-insensitive sorting. So I was wondering if sorting it on the client side is a good option. What do you think?

[ggazzo]

we could improve this PR https://github.com/RocketChat/Rocket.Chat/pull/9959

and insert one more attribute nameLowercase or blablabla transforming username/name to lowercase... @karlprieb what do you think?