I have a User model and a DegreeLevel model. And I...
# orm-help
s
I have a User model and a DegreeLevel model. And I've Linked the two with many to many. when I query with prisma client, instead of getting the degree level, I get the data of the many to many table. Is that the intenal return value? With typeorm I used to get the related models. How do I get the actual related model?
Copy code
model 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,
Copy code
const user = await this.prismaService.user.findFirst({
      where: { id },
      include: {
        degree_levels: true,
      },
    });
I get
Copy code
{
   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
Copy code
{
   id: 5,
   ...
   degree_levels: [
     DegreeLevel1, # values of degree level model
     DegreeLevel2
    
   ]
 }