Please, i need help. Is there a way for prisma gro...
# prisma-client
o
Please, i need help. Is there a way for prisma groupBy set default value instead of returning empty array
Copy code
const i = await this.prisma.transactions.groupBy({
      by: ['status'],
      where: {
        status: { in: ['APPROVED', 'COMPLETED', 'PENDING'] }
      },
      _count: {
        status: true
      }
    })
console.log(i) // []

// i need something like
// {approved: 0, pending: 0, completed: 0}
Thank you.