Hello all, I'm trying to use the preview filteredRelationCount feature and I have a question. How can I perform two counts on the same column with a different filter?

const items = await prisma.items.findMany({
    take: 12, orderBy: { title: 'asc' },
    include: {
        _count: {
            select: {
                votes: { where: { isUp: true } },
                votes: { where: { isUp: false } }, // ???
            }
        }
    }
});

like, I would like the two votes fields to be "upVotes" and "downVotes"? Thanks for any help!

Hey @Fergal Moran 👋 It seems you would need to create two separate queries, one for upvotes and the other for downvotes. For this use case, using AND or OR operators will also not be ideal.

Ok... thanks @Nurul