Hi, a known issue with mongodb.collection.sort() is that it is case sensitive. That is to say that is sorts A-Z, and then a-z. Mongo resolved this by adding the collation() method. How can one achieve this with a Find query in AppSmith or is this not supported yet?
TIA
@Elroy, Not sure whether collation is supported. Will check this with the team and update here. In the meantime, can you try the workaround suggested using an aggregate query here - java - Case insensitive sorting in MongoDB - Stack Overflow
Thank you for the work around, im not a fan of an unnecessary aggregations and projection but im sure it will be ok for small dataset. thank you for following up with the team.