Ordering by multiple columns in Prisma

Question

I know currently Prisma doesn't support ordering by multiple scalars fields, (see this issue: https://github.com/prisma/prisma/issues/62). But, I'm wondering if there is someone who found a solution to work around this issue without using executeRaw mutation (raw SQL) because I have many places in my code where I need to order by multiple fields and I don't want to use executeRaw in so many places. I will appreciate any suggestions. Thank you!

Fib · Accepted Answer · 2022-01-31 15:01:32Z

61

Since Prisma 2.4 this should be basically possible by using array in orderBy:

const users = await prisma.user.findMany({
   select: {
      email: true,
      role: true,
   },
   orderBy: [
      {
         email: 'desc',
      },
      {
         role: 'desc',
      }
   ],
})

Find more in docs: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#sort-user-by-multiple-fields---email-and-role

answered Jan 31, 2022 at 15:01

Fib

8478 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

panzi Over a year ago

Ok, but how do I write ... ORDER BY (foo = 1) DESC, bar ASC, foo ASC, baz ASC;?

Fib Over a year ago

What do you mean by (foo = 1) ?

panzi Over a year ago

I want rows where foo equals to 1 be sorted before the rest. In SQL you can do that as I've written it.

Gabriel Tong · Accepted Answer · 2019-04-30 18:23:29Z

1

I don't think there's a solution, In my project, I need random order, increment/decrement, aggregation... use raw finally.

answered Apr 30, 2019 at 18:23

Gabriel Tong

2163 silver badges12 bronze badges

Collectives™ on Stack Overflow

Ordering by multiple columns in Prisma

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related