Support MongoDB collation

[oallouch]

Hi,
Being able to use collation with Parse.Query (as a param of find or aggregate for instance) would be great for case insensitive searches.

What do you think about it ?

For now, I'll use the rawCollection using the 'not so internal' Config :)

Thx,
Olivier

[flovilmart]

@oallouch we already added additional options for the queries like the read preference. Collation would be in the same style. Do you have any documentation from mongodb?

[oallouch]

Of course
For standard queries:
https://docs.mongodb.com/manual/reference/method/cursor.collation/
For the aggregation framework (search 'collation' on this page)
https://docs.mongodb.com/manual/reference/method/db.collection.aggregate/

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[oallouch]

Any news on this one ?

[acinader]

hi @oallouch I got started on a related solution this past summer

to solve what I think is a bad and annoying shortcoming of parse: usernames and emails are case-sensitive in a way that they shouldn't be (see: #3990).

I haven't gotten the solution over the finish line, and your use-case may require us to rethink how I planned going about it. I'd love some help with finishing it (@dplewis :). But I haven't gotten any takers yet.

[oallouch]

Maybe all I need is an option parameter so that I can pass any mongo option to the native driver.
It's what I do now when I directly use the driver's collection.

[dplewis]

@acinader Sorry dropped the ball on that one. I was waiting for you to right a test.

@oallouch You are right. Feel free to open a PR. There are a lot of options like ReadPreference that get passed into mongo with the same style.

We are here to help. I’ll assign this to myself but I wont be able to get to it for a while.

[oallouch]

@dplewis ok, I'll try when I have more time.

[dplewis]

I’ll race you lol.

[oallouch]

I just saw your response, which means you'll win :)