Skip to content

Prisma, how to reverse order

New Course Coming Soon:

Get Really Good at Git

I was getting data from the database using Prisma.

In my specific case I was getting tweets from the Tweets table, and they were listed from oldest to newest.

I wanted the opposite, like Twitter works - the newest shows up first.

So I picked my data fetching procedure:

await prisma.tweet.findMany({})

and I added an orderBy attribute to order by id in descending order:

await prisma.tweet.findMany({
  orderBy: [
    {
      id: 'desc'
    }
  ]
})
→ Read my SQL Tutorial on The Valley of Code

Here is how can I help you: