Halvor
08/30/2021, 10:19 PMRyan
08/31/2021, 5:43 AM@@unique([uuid, boolean])
And then use it in findUnique.Halvor
08/31/2021, 6:39 AMHalvor
08/31/2021, 3:48 PMHalvor
08/31/2021, 3:49 PMSELECT
m.*
FROM "Map" AS m
JOIN "MapData" AS d ON d."mapId" = m.id
WHERE d.id = $1 AND m.deleted = trueRyan
09/01/2021, 6:20 AMawait prisma.map.findMany({
where: {
AND: [
{ mapData: { some: { id: 'some-id' } } },
{ deleted: true },
]
}
})
Change the fields as per your model.