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 }],
...
});
As it took me almost an hour to find this (chatGPT not being helpful), I wrote this article.
Cheers
Top comments (3)
Concise and to the point. Thank you very much. Chat GPT was trying to convince me that prisma doesn't support it xD
Thank you, the tears have already fallen from my face, thannnnkssssssss!!!!!!!
I just lost a few hours to this myself I wish I found this sooner, much appreciated!