How do I get the count in nested relations. - Prisma

Prisma•13mo ago•

4 replies

How do I get the count in nested relations.

Here I am trying to retrieve comment count for every post. How would I go about it?

  const posts = await prisma.posts.findMany({
    where: {
      userId,
    },
    orderBy: [
      { startDate: 'asc' },
    ],
    select: {
      id: true,
      title: true,
      image: true,
      publish: true,
      comments: {
        _count: {
            id: true
          }
      }
    }
  });

  const posts = await prisma.posts.findMany({
    where: {
      userId,
    },
    orderBy: [
      { startDate: 'asc' },
    ],
    select: {
      id: true,
      title: true,
      image: true,
      publish: true,
      comments: {
        _count: {
            id: true
          }
      }
    }
  });