Chip Clark
10/05/2021, 2:17 AMthis.prisma.committee.findMany({
include: {
PersonCommittee: {
include: {
Person: {
select: {
PKPersonID: true,
LastName: true,
FirstName: true,
MiddleName: true,
PreferredFirstName: true,
DisplayName: true,
EmploymentStatus: true
}
}
}
}
},
where: {
Active: true,
PersonCommittee: {
some: {
Person: {
OR: [
{
EmploymentStatus: "A"
},
{
EmploymentStatus: "L"
},
{
EmploymentStatus: "C"
},
],
}
}
}
}
})