typeorm

index.md

Repository 联查不支持 where，限制很多，使用 querybuild 和 leftJoinAndMapOne 方法可以将管理表作为一个属性

@Entity("record", { schema: "demo" })
export class Record {
  ...

  question: Question // 定义管理表挂载的属性
}

return await getRepository(Record)
      .createQueryBuilder('record')
      .leftJoinAndMapOne('record.question', Question, 'question', 'question.id = record.questionId')
      .where('record.tiku = :tiku and record.userId = :userId and result = 0', { tiku, userId })
      .groupBy('record.questionId')
      .getMany()