Prisma, how to reverse order

Jul 15, 2021

Learn how to reverse the order of results in Prisma by adding an orderBy clause to findMany and sorting by id in descending order to show the newest first.

~~~

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'
    }
  ]
})

Tagged: Database · All topics

~~~