Every single one of these Prisma filter queries is working

Question

Every single one of these Prisma filter queries is working

except the url one, the url one only works as expected when it's "true" but not when it's "false", the type is string and it's not a mandatory field

Some really basic notes:
- undefined in Prisma means that the filter is just not there, so it's not even applied
- null means an empty value for the record

file_id is of type Int (number), and url is of type string

where: {
file_id:
hasFile === "false"
? null
: { not: hasFile === "true" ? null : undefined },
url:
hasUrl === "false"
? null
: { not: hasUrl === "true" ? null : undefined },
isAccessible:
isAccessible === "false"
? false
: {
not: isAccessible === "true" ? false : undefined,
},
},

0

01.09.2024

1 ответов

2 просмотра

Anon · Answer 1

Anon Автор вопроса

What's even more absurd, it works just fine in development environment but not in production (yes they are the same version and I rebuilt the Next.js output just to be sure...) I don't know how to even go on about debugging this

0

2 месяца назад

Похожие чаты

Every single one of these Prisma filter queries is working

1 ответов

Похожие вопросы