I am trying to aggregate a count of rows where fie...
# orm-helpd
Dimitri Ivashchuk
09/19/2021, 7:57 AMI am trying to aggregate a count of rows where field is null, what am I doing wrong? 😄
Copy code
const countOfUnreadEvents = await prisma.event.aggregate({
_count: {
isRead: true,
},
where: {
isRead: null,
},
});Dimitri Ivashchuk
09/19/2021, 8:02 AMSelf answered 😄
Copy code
const countOfUnreadEvents = await prisma.event.count({
where: {
isRead: { equals: null },
},
});😄 1
r
Ryan
09/20/2021, 6:40 AMThe former should work as well. Is there any difference in the queries generated?
2 Views