Doctrine ORM QueryBuilder Association of Association ist bei mir null

Shopware 5 Programmierung
1

Wie schaffe ich es, dass die Media Daten von den Images von diesem Query nicht null sind?

        $builder = $this->getEntityManager()->createQueryBuilder();

        $builder->select([
            'variants',
            'attribute',
            'prices',
            'customerGroup',
            'options',            
            'images',
        ]);

        $builder->from('Shopware\Models\Article\Detail', 'variants')
            ->innerJoin('variants.article', 'article')
            ->leftJoin('variants.attribute', 'attribute')
            ->leftJoin('variants.images', 'images')
            ->leftJoin('variants.prices', 'prices')
            ->innerJoin('prices.customerGroup', 'customerGroup')
            ->leftJoin('variants.configuratorOptions', 'options');

        $builder->andWhere('article.id = :articleId')
            ->andWhere('variants.kind = 2')
            ->leftJoin('options.attribute', 'optionsAttribute')
            ->leftJoin('images.media', 'imagesMedia')
            ->addSelect('optionsAttribute')
            ->addSelect('imagesMedia')
            ->setParameter('articleId', (int)$articleId);

        $builder->getQuery()->getArrayResult()

 

2

Ok, gelöst. Anscheinend muss ich mir das parent image erst dazuladen:

            ->leftJoin('images.parent', 'parentImage')
            ->leftJoin('parentImage.media', 'parentMedia')     
            ->addSelect('parentImage')
            ->addSelect('parentMedia')