Doctrine2: How to select ArrayCollection using DQL

Question

I've two entities which has OneToMany mapping just the way described in doctrine docs:

 // Product Entity
 /**
  * @OneToMany(targetEntity="Feature", mappedBy="product")
  */
  private $features;

 // Feature Entity    
 /**
  * @ManyToOne(targetEntity="Product", inversedBy="features")
  * @JoinColumn(name="product_id", referencedColumnName="id")
  */
  private $product;

When I do findAll() on Product then it returns products with array of Feature.

I'm using DQL to query and so I want to know how do I select array of Feature using DQL.

I did: SELECT p.name, p.price, f FROM Product p JOIN p.features f

but it gives an error

Cannot select entity through identification variables without choosing at least one root entity alias.

I also tried: SELECT p.name, p.price, p.features FROM Product p

which also gives an error

Invalid PathExpression. Must be a StateFieldPathExpression.

Can you please ost your PHP code also? The DQL does not look wrong by itself, but maybe how you are calling it is the issue. — romaricdrigon
– romaricdrigon, Commented Jul 12, 2016 at 8:09

abdiel · Accepted Answer · 2016-07-12 13:46:18Z

1

The problem is that you can't get the Features entities without getting a Product for contain it. So you must do

SELECT p , f FROM Product p JOIN p.features f

Hope this help you.

answered Jul 12, 2016 at 13:46

abdiel

2,11619 silver badges24 bronze badges

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

Comments

Leonid Zakharov · Accepted Answer · 2016-07-14 02:28:21Z

0

@abdiel gives right solution

class ProductsRepository extends \Doctrine\ORM\EntityRepository
{

    public function getAllProductsWithFeatures()
    {
        $dql = 'SELECT p , f FROM Product p JOIN p.features f';
        $query = $this->getEntityManager()->createQuery($dql);
        return $query->getResult();
    }

}

Then for example in controller:

$products = $this->get('doctrine')->getRepository('YourBundle:Product')->getAllProductsWithFeatures();

All products will be with preloaded collections of features.

Good luck!

answered Jul 14, 2016 at 2:28

Leonid Zakharov

9701 gold badge6 silver badges11 bronze badges

Collectives™ on Stack Overflow

Doctrine2: How to select ArrayCollection using DQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related