search

mingo-app / mingo

Found a bug? have a FR ?
59 stars 3 forks source link

[FR] Set collation in query #546

Closed thiagotsn closed 1 year ago

thiagotsn commented 1 year ago

Is your feature request related to a problem? Please describe. Not sure if it's current possible outside of node shell, but I would like to set the collation in a given document query. Sometimes I need to sort strings regardless of being lower or upper case.

Describe the solution you'd like Maybe have an option below sorting, or just appearing on demand.

Describe alternatives you've considered Using the node shell is clearly an option.

Additional context

tothradoslav commented 1 year ago

We have added this as a new option besides "sort" in documents.

thiagotsn commented 1 year ago

Awesome! That will work.

tothradoslav commented 1 year ago

This has been corrected in the last version. Please let us know if it is OK.

https://github.com/mingo-app/mingo/releases/tag/v1.12.0

thiagotsn commented 1 year ago

Working good, @tothradoslav. Thank you!

jefft043 commented 1 year ago

Is there a way to turn off the use of collation globally? I'm connecting to an Atlas serverless instance which doesn't support this feature and now unable to view any collections since the latest update.

Thanks

tothradoslav commented 1 year ago

Oops, sorry about that. We will be adding "Projection" as an option, too, but it will be "optional" by default. We will also make the collation optional, too.

I have also changed the behavior, so that if the collation is empty {} then it's ignored. This will be out in next patch.

jefft043 commented 1 year ago

Nice one, looking forward to the patch - projection will be useful too!

dashersw commented 1 year ago

Oh I just updated to 1.12.1 and because of collation can't use Atlas Serverless :( really looking forward to a patch.

tothradoslav commented 1 year ago

Hi, this has been resolved in the latest patch, please check it out here:

https://github.com/mingo-app/mingo/releases/tag/v1.12.2

darwin-buelo commented 1 year ago

Hi, this has been resolved in the latest patch, please check it out here:

https://github.com/mingo-app/mingo/releases/tag/v1.12.2

Thank I just tested this one on my machine and my problem #569 is now solved