Case insensitive orderBy #194
ericchernuka
started this conversation in
Ideas
Replies: 1 comment 10 replies
-
Hey, @ericchernuka. Thanks for suggesting this! I think this is a great idea. Our API is heavily inspired by Prisma, and they have a similar issue open (prisma/prisma#5068). We, however, don't have support for something like a What do you think about the following API? db.user.findMany({
where: criteria,
orderBy: {
username: {
direction: 'asc',
mode: 'insensitive'
}
}
}) I'm not a fan of complicating the I'd like to hear your opinion on how you'd expect this API to look. |
Beta Was this translation helpful? Give feedback.
10 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I'm just running into this and thought I'd see if there's any interest in having the ability to use a
localeCompare
option on the orderBy rather than>
|<
on the string. Just running into situations where things are out of order due to casing.Beta Was this translation helpful? Give feedback.
All reactions