Is there a way to query my db where a field is not null like

Question

Is there a way to query my db where a field is not null like db post findMany where category null or something

Alex Vilchis · Answer

Wrap it in `not `

Oliver Evans · Answer

i e `db post findMany where category not null `

Shehab · Answer

Great thanks

Joseph · Answer

Lol just asked the same question Where is the `findMany` function coming from

Joseph · Answer

```const existingMatches = await prisma query matches where endedAt not null info ``` This throws an error `GraphQL error Variable $ v0 where expected value of type MatchWhereInput but got endedAt not null Reason endedAt Date value expected`

Anton Pokhylenko · Answer

try ``` where not endedAt null ```

Joseph · Answer

Same issue I m guessing I need to do something like `NOT ` if I needed where it s not null My issue is I can t filter by `null` at all

Joseph · Answer

I m using `prisma` from `prisma binding` passed in through the context in the resolver Perhaps the issue is that I m not using `db` but i m also not sure where that s coming from

Ryan · Answer

Hey < Joseph> wave Are you using Prisma1

Joseph · Answer

Hey < Ryan> sure am slightly smiling face

Joseph · Answer

< Ryan> Is there a way to filter by null in Prisma1

Is there a way to filter by null in Prisma1?