Among the entities I'm working with are:
Group {
id: number;
name: string;
persons: Person[];
}
Person {
name: string;
items: Item[];
}
Item {
name: string;
active: boolean;
}
What I have at my disposal: an array containing group id's groupIds.
My Objective: To obtain an array of Item objects, specifically those that belong to groups with IDs present in the given array and have the property active set to true.
I attempted to construct a query builder as follows:
this.groupRepository.createQueryBuilder('group')
.innerJoin('group.persons', 'persons')
.innerJoinAndSelect('persons.items', 'items')
.where({'items.active': true, 'group.id': In(groupIds)})
.getMany();
Unfortunately, this approach only returns an array of group objects without any associated relationships that contain valid item entries.
What modifications should be made to achieve this desired result, ideally within a single query?