Prisma•2y ago

Prisma `AND` filter not working

await prisma.user.update({
where: {
    AND: [
        { id: req.params.id },
        { deleted: false },
      ],
},
//...
})

await prisma.user.update({
where: {
    AND: [
        { id: req.params.id },
        { deleted: false },
      ],
},
//...
})

this is my snippet, I am trying to update the user if the id is available and also the deleted is false.

SparrowOP•5/8/24, 9:18 AM

any idea what went wrong??