Skip to content

Prisma, how to reverse order

FULL-STACK WEB DEVELOPMENT BOOTCAMP

2024 COHORT SIGNUPS END TOMORROW

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
  • Learn modern web development in my BOOTCAMP (SIGNUP END TOMORROW FEB 20, 2024)
  • THE VALLEY OF CODE (+ PRO), your web development manual
  • I wrote 15+ coding BOOKS, all available in THE VALLEY OF CODE PRO
  • Indie solopreneur internet business masterclass SOLO LAB (summer 2024)