# billing\[number\] heufig leer

**URL:** <https://forum.shopware.com/t/billing-number-heufig-leer/30296>\
**Category:** Programmierung\
**Created:** [7. September 2015 um 17:51 UTC](https://forum.shopware.com/t/billing-number-heufig-leer/30296 "2015-09-07T17:51:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pino](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/pino/32/14373_2.png) [@pino](https://forum.shopware.com/u/pino)\
**Post date:** [7. September 2015 um 17:51 UTC](https://forum.shopware.com/t/billing-number-heufig-leer/30296/1 "2015-09-07T17:51:53Z")

</div>

hi, folgende doctrine abfrage führe ich aus. ` $builder = Shopware()-\>Models()-\>createQueryBuilder(); $builder-\>select(array( 'orders', 'billing' )) -\>from('Shopware\Models\Order\Order', 'orders') -\>leftJoin('orders.billing', 'billing') -\>where('orders.number IS NOT NULL') -\>andWhere('orders.orderTime \>= 2015-09-05') -\>setFirstResult(0) -\>setMaxResults(5) -\>orderBy('orders.id', 'DESC'); $data = $builder-\>getQuery()-\>getArrayResult(); ` ausgabe: ` Array ( [0] =\> Array ( [id] =\> 13368 [number] =\> 41511 ... [billing] =\> Array ( [id] =\> 9557 [orderId] =\> 13368 [number] =\> 40197 ... ) ) [1] =\> Array ( [id] =\> 13367 [number] =\> 41510 ... [billing] =\> Array ( [id] =\> 9556 [orderId] =\> 13367 [number] =\> ... ) ) ... ) ` es sind sehr viele billing[number] leer ☹ warum? // edit stelle gerade fest das alle leer sind, die status 2 sind. ` -\>andWhere('orders.status = 2') `