TypeOrm Postgres two level nesting

Question

Customer has 0 or more OilSeparator, and OilSeparator has 0 or more Inspection. How do I fetch a customer with it's OilSeparators that in turn has it's Inspections?

I want to do this:

this.customerRepository.findOne({
      where: { id },
      relations: ['oilSeparators, oilSeparators.inspections'],
    });

but it's not supported as far as I can see. Do you know how to do this with createQueryBuilder ?

Kareem Adel · Accepted Answer · 2022-07-10 16:49:57Z

1

you need to use queryBuilder example :

this.customerRepository 
      .createQueryBuilder('customer')
      .innerJoinAndSelect('customer.oilSeparators', 'oilSeparators')
      .innerJoin("oilSeparators.inspections", "inspections")
      .getRawOne()

or use eager: true in inspections Entity

also you can use .relation(OilSeparator, "customer.OilSeparator.inspections")

if you need moro information about join read this

answered Jul 10, 2022 at 16:49

Kareem Adel

7045 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

TypeOrm Postgres two level nesting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related