prisma-binding icon indicating copy to clipboard operation
prisma-binding copied to clipboard

How to filter `Where null`

Open baconcheese113 opened this issue 5 years ago • 1 comments

I'm using Prisma 1 with Prisma Binding and a Postgresql DB.

Is there a way to find rows where a field is null?

This is what I would expect, but doesn't appear to be supported:

prisma.query.matches({ where: { endedAt: null } }, info)

baconcheese113 avatar Apr 30 '20 01:04 baconcheese113

Same problem. How can i select records with null? Tried "where: { prop: { equals: null } }" but still result is empty list, no errors

sevdok avatar Oct 07 '20 22:10 sevdok