Hi, wondering if this is possible? 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"] },
            },
          },

There’s a

notIn

operator that might be what you’re looking for: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#notin

Is this possible on a JSON field?

Not possible to the best of my knowledge. JSON filtering only supports

array_contains

, not the inverse ( something like

array_does_not_contain

)