Prisma•2mo ago

Checking Null or empty list

I have a field of type integer list in my DB. I want to add a filter if is empty or null,

{
  OR: [
    { myList: { isEmpty: true } },
    { myList: { equals: null } }
  ]
}

{
  OR: [
    { myList: { isEmpty: true } },
    { myList: { equals: null } }
  ]
}

But I am getting this error

Argument `equals`: Invalid value provided. Expected Null, provided (Null)."

Argument `equals`: Invalid value provided. Expected Null, provided (Null)."

I had tried a lot of the stuff already, but I don't know how to fix this error, any help pls?

3 Replies

Hi @Dobleuber Can you try this ?

import { Prisma } from '@prisma/client'

 {
  OR: [
    { myList: { isEmpty: true } },
    { myList: { equals: Prisma.DbNull } }
  ]
}

import { Prisma } from '@prisma/client'

 {
  OR: [
    { myList: { isEmpty: true } },
    { myList: { equals: Prisma.DbNull } }
  ]
}

How to read, write, and filter by Json fields.

DobleuberOP•2mo ago

I tried already, It didn’t work.

Can you please share your schema