Chip Clark
01/11/2022, 11:11 PMconst whereClause = {
AND: [
{
InvoiceTransaction: {
some: {
InvoiceDate: { gt: horizon }
}
}
},
{
...(searchString?
{
VendorName: { contains: searchString },
}
: {}),
}
]
}
The schema
model Vendor {
VendorPKID Int @id @default(autoincrement())
VendorUno Int @unique
VendorNumber Int?
VendorID String? @db.VarChar(10)
VendorName String? @db.VarChar(40)
NameUno Int?
VendorTypeCode String? @db.VarChar(5)
AddressUno Int?
Address1 String? @db.VarChar(60)
Address2 String? @db.VarChar(60)
City String? @db.VarChar(60)
State String? @db.VarChar(5)
PostalCode String? @db.VarChar(50)
Note String? @db.VarChar(Max)
Active Boolean @default(false)
ActiveFromDate DateTime @db.Date
ModifiedDate DateTime @default(now()) @db.DateTime
ModifiedBy String @db.VarChar(30)
InvoiceTransaction InvoiceTransaction[]
}
Setting horizon to: 2020-01-11T000000.000Z or 2015-01-11T000000.000Z makes no difference. Both return the same recordsChip Clark
01/11/2022, 11:18 PMconst whereClause = {
AND: [
{
InvoiceDate: { gt: horizon }
},
{
...(searchString?
{
CombinedNarrative: { contains: searchString }
}
: {})
}
]
}Chip Clark
01/12/2022, 11:21 PM