Checking Null or empty list

[nimble gorge]

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 } }
  ]
}

But I am getting this error

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?

[serene wraith]

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

[royal merlin]

Hi @nimble gorge

Can you try this ?

import { Prisma } from '@prisma/client'

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

See this documentation https://www.prisma.io/docs/orm/prisma-client/special-fields-and-types/working-with-json-fields#filtering-by-null-values

[nimble gorge]

I tried already, It didn’t work.