How to get included model data count in prisma with where clause?

Question

i need to get user details with post count(Number of posts for today).

const usersWithCount = await prisma.user.findMany({
      select: {
        _count: {
          select: {
            posts: {
             where: {
                       createdAt: moment().format("YYYY-MM-DD"),
                    },
                  },
            recipes: true,
          },
        },
      },
    })

Pompedup · Accepted Answer · 2022-11-22 15:50:33Z

1

You cannot filter in relations count, this is not currently supported by prisma. Here is the Feature Request for adding filters in relations count. In your use case you can get filtered relations as described below:

  const usersWithCount = await prisma.user.findMany({
    select: {
      posts: {
        where: {
          createdAt: moment().format("YYYY-MM-DD"),
        },
      },
      recipes: true
    },
  });

In the response of the above query you will get posts array with records satisfying your where condition, you can use the array's length as a count.

edited Nov 22, 2022 at 15:50

Pompedup

6363 silver badges8 bronze badges

answered Feb 25, 2022 at 10:07

Nurul Sundarani

7,8983 gold badges39 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get included model data count in prisma with where clause?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related