Prisma•14mo 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?

RaphaelEtim•10/30/24, 9:25 AM

Hi @Dobleuber

Can you try this ?

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

DobleuberOP•10/30/24, 11:18 AM

I tried already, It didn’t work.

RaphaelEtim•10/30/24, 11:26 AM

Can you please share your schema