Is there a way to query for rows where a field is ...
# orm-help
j
Is there a way to query for rows where a field is null? Like
Copy code
prisma.query.matches({ where: { endedAt: null } }, info)
This doesn't work for me
c
@Joseph Here is a working example for the 
User
 and 
Post
 models:
Copy code
const posts = await prisma.posts.findMany({
  where: {
    OR: [
      { author: null },
      {
        title: {
          contains: 'Hello',
        },
      },
    ],
  },
})
j
Thanks for the reply! Where is the
findMany
function coming from?