Adding "OR" inside nested "where" returns nothing.
Removing "OR" inside nested "where" returns the results.
What's the issue?
Asked
Active
Viewed 170 times
0
-
Could you maybe replace your screenshot with a code block please? Moreover, could you provide the related prisma.schema models definition? – Jordan Quagliatini Feb 27 '23 at 19:30
-
`schema.prisma` contains 500 lines. also, not sure this query will help since it's 70 lines long. the only thing that changes is the "OR", which shouldn't influence the data returned, but for some reason - it does. is this a known issue with nested "OR" not returning any data? – aivarastee Feb 28 '23 at 03:31
-
I've just tested again, same result. I think `take` or `skip` may be influencing it when "where" is nested. – aivarastee Feb 28 '23 at 04:13