How can I join multiple tables with TypeORM leftJoinAndSelect?

user_239879 0
Viewed 104

I have:

this.createQueryBuilder('company')
      .leftJoinAndSelect('company.companyAdmins', 'companyAdmins')
      .leftJoinAndSelect('companyAdmins.user', 'user')
      .where('company.id = :id', { id })
      .getOne();

I want to also get all invitations that match that company. My invitation model has:

@Index()
  @ManyToOne(() => Company)
  public company: Company;
typeorm postgresql javascript
1 Answers

Did you try this?

this.createQueryBuilder('company')
  .leftJoinAndSelect('company.companyAdmins', 'companyAdmins')
  .leftJoinAndSelect('companyAdmins.user', 'user')
  .leftJoinAndSelect('company.invites', 'invites') // Adding this
  .where('company.id = :id', { id })
  .getOne();

Your Company entity should have:

@OneToMany(
  type => Invite,
  invite => invite.company,
)
invites?: Invite[];
user_43842380
Related