Michael
09/27/2022, 11:25 PMOR
actually functional? there's no OR present in the generated SQL and instead it seems to be generating the same SQL as when the OR is an AND:await prismaClient.objective.findMany({
where: {
patientId: id,
OR: { // replace with AND makes no difference
branchingOptionId: { not: null },
conversationItemId: { not: null },
},
},
});
// generates: SELECT Objectives.id, ... WHERE (Objectives.patientId = 1 AND Objectives.branchingOptionId IS NOT NULL AND Objectives.conversationItemId IS NOT NULL)
janpio
Michael
09/27/2022, 11:53 PMjanpio
Michael
09/28/2022, 2:50 PMjanpio
Michael
09/28/2022, 2:51 PMjanpio