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.

1 Reply

Sparrow•6mo ago

any idea what went wrong??

The official Discord for the Prisma ORM and Prisma Data Platform! Learn more at https://prisma.io

6.2KMembers

Want results from more Discord servers?