YErii
06/03/2021, 8:11 AMnotIn operator?
for example we have 5 users, 3 is in the condition and 2 is not. if we execute
prisma.user.findMany({where: {notIn: [...]}}) will return 7 result.
the above is to clarify the problem and the real count may be 5000 items in notIn clause which returns wrong result.
But prisma.user.count(...) and prisma.user.findMany({where: {NOT: {in: []}}}) are ok