doctrine 2 query builder count one to many relationship

Question

I have the following query:

 $em = $this->getEntityManager(); $query = $em->createQueryBuilder()->select('shoppingcart') ->from("AppMainBundle:ShoppingCart", 'shoppingcart') ->innerJoin('shoppingcart.shoppingCartProducts', 'shoppingcartproduct') ->innerJoin('shoppingcartproduct.product', 'product') ->innerJoin('shoppingcartproduct.productAttribute', 'productattribute') ->innerJoin('product.shop', 'shop') ;

how do I write a where statement, where I only want to get shoppingcart that has more than one shoppingcartproduct in it? Here's the relationship of shopping cart and shoppingcart product:

class ShoppingCart { /** * @var integer $id * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /** * @ORM\OneToMany(targetEntity="ShoppingCartProduct", mappedBy="shoppingCart", cascade={"persist","remove"}) */ protected $shoppingCartProducts; }

Alexey B. · Accepted Answer · 2013-09-07 04:10:03Z

3

Try to add following lines

->addSelect('COUNT(shoppingcartproduct) as nProducts') ->addGroupBy('shoppingcart.id') ->having('nProducts > 1')

answered Sep 7, 2013 at 4:10

Alexey B.

12k2 gold badges51 silver badges76 bronze badges

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

3 Comments

Rajesh Meniya Over a year ago

How can I access "nProducts" from result of query? here I use getResult() on query object.

AlexandruSerban Over a year ago

$result[0] will be Shoppingcart, $result['nProducts'] = 123;

Franz Zieris Over a year ago

In case the query should return an array of objects and the actual number of products does not matter, the select clause should be COUNT(shoppingcardproduct) AS HIDDEN nProducts.

Collectives™ on Stack Overflow

doctrine 2 query builder count one to many relationship

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related