PrismaP
Prisma•2y ago•
2 replies
thejacer87

check for multiple conditions on the same field

i think there is a simple solution that i am over looking

but i am building this query:

 where: {
      AND: [
        { key_id: { in: branchKeyIds } },
        { key_id: { notIn: machineSpecificKeyIds } },
        { key_id: { notIn: inHouseTestKeyIds } },
        { key_id: { notIn: weekendKeyIds } },
        { key_id: { notIn: win32OnlyKeyIds } },
        { test_num: { notIn: exclusionTestNums } },
        { test_num: { lt: 24000 } },
      ],
    },


but i am not getting the data that i would expect

it this not the correct way to have multiple ANDs for a single field
Was this page helpful?