Alex Vilchis
02/03/2022, 9:12 PMAustin Zentz
02/03/2022, 9:13 PMAustin Zentz
02/03/2022, 9:13 PMAlex Vilchis
02/03/2022, 9:16 PMprisma.customer.findMany({
"where":{
"organizationId":{
"equals":"asdf"
},
"AND":[
{
"name":{
"search":"+fern"
}
},
{
"archivedAt":{
"equals":null
}
}
]
},
"skip":0,
"take":15,
"orderBy":{
"createdAt":"desc"
}
})
My model:
model Customer {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String
username String
email String?
organization Organization @relation(fields: [organizationId], references: [id])
organizationId String
@@unique([username, organizationId])
@@unique([email, organizationId])
@@fulltext([name])
@@fulltext([username])
@@fulltext([name, username])
}
Alex Vilchis
02/03/2022, 9:17 PMAlex Vilchis
02/03/2022, 9:18 PMAlex Vilchis
02/03/2022, 9:21 PMAND
Austin Zentz
02/03/2022, 9:21 PMAlex Vilchis
02/03/2022, 9:22 PMnikolasburk