2

I am trying to do some more complex query like this using prisma.io:

prisma.someModel.findMany({
    where: {
      AND: [
        {
          OR: [
            { firstName: { contains: 'John' } },
            { lastName: { contains: 'John' } }
          ]
        },
        {
          OR: [
            { firstName: { contains: 'Doe' } },
            { lastName: { contains: 'Doe' } }
          ]
        }
      ]
    }
})

Is there a way to do something like this?

juliomalves
  • 42,130
  • 20
  • 150
  • 146

0 Answers0