DEV Community

Martin Ratinaud
Martin Ratinaud

Posted on

Prisma "null or does not exists"

I've been using Prisma on my latest project Karaoke Tools and as crazy as it may seem, I did not find any easy way (like a plugin) to handle soft delete behaviour.

So I had to tweak it myself manually and ending up in a case where

  • deletedAt can be null
  • deletedAt can NOT exist

This is because I'm using mongo and no default value for deletedAt.

This filtering in Prisma is not handled by default (like deletedAt: null so I had to do it with an OR request.


const items = await prisma.event.findMany({
    ...
    where: filters: {
      OR: [{ deletedAt: { isSet: false } }, { deletedAt: null }],
    ...
  });

Enter fullscreen mode Exit fullscreen mode

As it took me almost an hour to find this (chatGPT not being helpful), I wrote this article.

Cheers

Top comments (3)

Collapse
 
gustawdaniel profile image
Daniel Gustaw

Concise and to the point. Thank you very much. Chat GPT was trying to convince me that prisma doesn't support it xD

Collapse
 
claudsondouglas profile image
Claudson

Thank you, the tears have already fallen from my face, thannnnkssssssss!!!!!!!

Collapse
 
mrispoli24 profile image
Mike Rispoli

I just lost a few hours to this myself I wish I found this sooner, much appreciated!