Hey curious how can I construct a query to fetch tag which h Prisma #orm-help

Hey, curious how can I construct a query to fetch ...

Maotora

02/07/2022, 3:19 PM

Hey, curious how can I construct a query to fetch tag which has the most contents (relations)? Eg.

Copy code

Tag {
    contents    Content[]
    name        String      @unique
}

Would need to order tag which has most content first.

Maotora

02/07/2022, 7:24 PM

Got it

Copy code

const popularTags = await prisma.tag.findMany({
  orderBy: {
    contents: {
      count: 'desc',
    },
  },
})