# Doctrine ORM QueryBuilder Association of Association ist bei mir null

**URL:** <https://forum.shopware.com/t/doctrine-orm-querybuilder-association-of-association-ist-bei-mir-null/53665>\
**Category:** Programmierung\
**Created:** [22. Juni 2018 um 12:22 UTC](https://forum.shopware.com/t/doctrine-orm-querybuilder-association-of-association-ist-bei-mir-null/53665 "2018-06-22T12:22:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![langnickel](https://avatars.discourse-cdn.com/v4/letter/l/3ec8ea/32.png) [@langnickel](https://forum.shopware.com/u/langnickel)\
**Post date:** [22. Juni 2018 um 12:22 UTC](https://forum.shopware.com/t/doctrine-orm-querybuilder-association-of-association-ist-bei-mir-null/53665/1 "2018-06-22T12:22:32Z")

</div>

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()

```

&nbsp;

---

<div class="post-metadata">

**Author:** ![langnickel](https://avatars.discourse-cdn.com/v4/letter/l/3ec8ea/32.png) [@langnickel](https://forum.shopware.com/u/langnickel)\
**Post date:** [22. Juni 2018 um 12:59 UTC](https://forum.shopware.com/t/doctrine-orm-querybuilder-association-of-association-ist-bei-mir-null/53665/2 "2018-06-22T12:59:23Z")

</div>

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

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

```

&nbsp;