Have this situation:
```let details: JsonValue | ...
# orm-helpd
David Ilizarov
10/13/2022, 11:28 PMHave this situation:
Copy code
let details: JsonValue | Prisma.DbNull = Prisma.DbNull;
// object.details is JsonValue
object.details = details === Prisma.DbNull ? null : details;
// Error: Type 'JsonValue | DbNull' is not assignable to type 'JsonValue'.
// Type 'DbNull' is not assignable to type 'JsonValue' Copy code
object.details = details instanceof Prisma.NullTypes.DbNull ? null : details;
// This works ^^^💬 1
✅ 1
v
Vladi Stevanovic
10/14/2022, 1:51 PM
👋 Hey @David Ilizarov - as a side note - I've asked our Docs team to confirm if we don't have this document and if they can provide some clarity
Have you perhaps had a chance to review this doc: https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields#filtering-by-null-values
I believe you would need to use
JsonNullVladi Stevanovic
10/15/2022, 6:36 AM
@David Ilizarov I have a bit more information for you here!
This is how it used to work before
4.0.0 Copy code
import { PrismaClient, Prisma } from ".prisma/client"
let detail: Prisma.JsonValue | typeof Prisma.DbNull = Prisma.DbNull
let detail2: Prisma.JsonValue
detail2 = detail === Prisma.DbNull ? null : detail4.0.0instanceof Copy code
import { PrismaClient, Prisma } from ".prisma/client"
let detail: Prisma.JsonValue | typeof Prisma.DbNull = Prisma.DbNull
let detail2: Prisma.JsonValue
detail2 = detail instanceof Prisma.DbNull ? null : detailVladi Stevanovic
10/15/2022, 6:37 AM
You can also find more information here: Improve the UX of null values with JSON fields. Ultimately, we agree this is a confusing area and want to fix it! 😊
d
David Ilizarov
10/15/2022, 6:41 AMOh cool — I see you all are aware that there are quirky issues that should be looked into. Good luck!
🙌 1
👍 1
v
Vladi Stevanovic
10/15/2022, 6:43 AM
Thank you! 😅 🤞
3 Views