Use Array of Values to Filter JSON?

user_6244276 0
Viewed 123

Having an array of manufacturerID's, how can I exclude results by the id's in the array?

Is this possible on a JSON field?

 {
            Manufacturer: {
              path: ["manufacturerID"],
              not: { in: ["28", "266", "213", "234"] },
            },
          },
prisma
1 Answers

This doesn't not appear to be possible, so I have gone with:

 NOT: {
          OR: [
            { Manufacturer: { path: ["manufacturerID"], equals: "28" } },
            { Manufacturer: { path: ["manufacturerID"], equals: "266" } },
            { Manufacturer: { path: ["manufacturerID"], equals: "213" } },
            { Manufacturer: { path: ["manufacturerID"], equals: "234" } },
          ],
        },
user_62442760
Related