thejacer87
thejacer87
Explore posts from servers
NNuxtPPrisma
PostsComments
PPrisma
Created by thejacer87 on 8/14/2024 in #help-and-questions
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 } },
      ],
    },
 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
3 replies