how to filter null property inside where?
# orm-helpg
Gelo
08/10/2021, 11:36 AMhow to filter null property inside where?
r
Ryan
08/10/2021, 11:40 AMwhere: { field: null }❤️ 1
g
Gelo
08/10/2021, 11:42 AM@Ryan how about if the field is a relation to other schema?
r
Ryan
08/10/2021, 11:43 AMCan you share the model and relation?
g
Gelo
08/10/2021, 11:44 AMSolved it!! prisma type safety is awesome. OR: [
{
workType: {
type: {
equals: 'On site',
},
},
},
{
workTypeId: null,
},
]
prisma cool 1
🙌 1
Gelo
08/10/2021, 11:53 AMcan't reuse where object
Gelo
08/10/2021, 11:53 AMType '{ visitorId: { readonly equals: number; }; siteId: { readonly equals: number; }; OR: readonly [{ readonly workType: { readonly type: { readonly equals: "On site"; }; }; }, { readonly workTypeId: any; }]; dateCreated: { ...; }; timeCreated: { ...; }; }' is not assignable to type 'VisitWhereInput'.
Types of property 'OR' are incompatible.
Type 'readonly [{ readonly workType: { readonly type: { readonly equals: "On site"; }; }; }, { readonly workTypeId: any; }]' is not assignable to type 'Enumerable<VisitWhereInput>'.
The type 'readonly [{ readonly workType: { readonly type: { readonly equals: "On site"; }; }; }, { readonly workTypeId: any; }]' is 'readonly' and cannot be assigned to the mutable type 'VisitWhereInput[]'.
Gelo
08/10/2021, 11:54 AM@Ryan
r
Ryan
08/10/2021, 11:58 AMCould you try removing
as const❤️ 1
g
Gelo
08/10/2021, 12:00 PM@Ryan thank you ryan 🙂 big help!
Gelo
08/10/2021, 12:02 PMIs there a feature in prisma where we can rename field property? eg: select floor as 'siteFloor'
r
Ryan
08/10/2021, 12:04 PMNot yet, but it would be great if you could add a 👍 to this feature request and follow for more updates:
https://github.com/prisma/prisma/issues/4433
❤️ 1
h
Harjaap Singh Makkar
09/01/2021, 12:24 AM@Ryan Hello, I'm trying to do this same thing but I can't re-use my where object. Any help would be awesome!
Type '{ uid: string; status: string | { in: string[]; }; subType: { in: any; }; type: { in: any; }; price: { gte: any; lte: any; }; OR: ({ subject: { contains: any; mode: string; }; marketing?: undefined; province?: undefined; ... 5 more ...; User?: undefined; } | ... 9 more ... | { ...; })[]; timeStamp: { ...; }; User: {...' is not assignable to type 'ListingWhereInput'.Types of property 'OR' are incompatible.Type '({ subject: { contains: any; mode: string; }; marketing?: undefined; province?: undefined; city?: undefined; postal?: undefined; subType?: undefined; type?: undefined; address?: undefined; User?: undefined; } | ... 9 more ... | { ...; })[]' is not assignable to type 'Enumerable<ListingWhereInput>'.Type '({ subject: { contains: any; mode: string; }; marketing?: undefined; province?: undefined; city?: undefined; postal?: undefined; subType?: undefined; type?: undefined; address?: undefined; User?: undefined; } | ... 9 more ... | { ...; })[]' is not assignable to type 'ListingWhereInput[]'.ts(2322)index.d.ts(2064, 5): The expected type comes from property 'where' which is declared here on type '{ select?: ListingSelect; include?: ListingInclude; where?: ListingWhereInput; orderBy?: Enumerable<ListingOrderByInput>; cursor?: ListingWhereUniqueInput; take?: number; skip?: number; distinct?: Enumerable<...>; }'r
Ryan
09/01/2021, 6:18 AM@Harjaap Singh Makkar Try adding the type to
where Copy code
const where: Prisma.ListingWhereInput = {}whereh
Harjaap Singh Makkar
09/01/2021, 6:44 PMThank you, Ryan. For 'Prisma.' am I using the prisma object imported from the image attached? (I'm in nextjs). Because in this case it says "Cannot find namespace 'Prisma' even though I'm using prisma for all the other queries in this file as shared in the photo shared earlier
Harjaap Singh Makkar
09/01/2021, 7:50 PMNevermind, I got it, had to import { Prisma } from PrismaClient 🙂
💯 1
6 Views