sagar lama
02/17/2022, 10:44 AMmodel User {
...
degree_levels UserDegreeLevels[]
}
model DegreeLevel {
...
users User[]
}
model UserDegreeLevels {
id Int @id @default(autoincrement())
degree_level DegreeLevel @relation(fields: [degreeId], references: [id], onDelete: Cascade)
degreeId Int
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
userId Int
created_at DateTime @default(now())
updated_at DateTime @updatedAt
}
When i execute the following query,
const user = await this.prismaService.user.findFirst({
where: { id },
include: {
degree_levels: true,
},
});
I get
{
id: 5,
...
degree_levels: [
{
id: 1,
uuid: '1cca9b39-af0b-4219-a951-93f205fab67f',
degreeId: 10,
userId: 5,
created_at: 2022-02-17T09:00:52.024Z,
updated_at: 2022-02-17T09:00:52.025Z
},
{
id: 2,
uuid: '709ee342-e6d5-4e49-8d23-6339cf0fb0d6',
degreeId: 11,
userId: 5,
created_at: 2022-02-17T09:00:52.024Z,
updated_at: 2022-02-17T09:00:52.025Z
}
]
}
The result I want
{
id: 5,
...
degree_levels: [
DegreeLevel1, # values of degree level model
DegreeLevel2
]
}