CODEWITHSUNDEEP
phpmysqlsymfonydoctrine-ormdoctrine
Jeremy
Jeremy

Reputation: 554

Doctrine Complex Inner Join

I'm working on a complex inner join using doctrine. My query is: 

    SELECT purchased_items.previewurl, purchased_items.ordernumber, orders.shipByDate, CustomerDesign.designData, fos_user.email
    FROM FYPEmailsBundle:purchased_items purchased_items
    INNER JOIN purchased_items.orders orders
    INNER JOIN orders.CustomerDesign CustomerDesign
    INNER JOIN CustomerDesign.User fos_user

When I run the query I get Class FYP\EmailsBundle\Entity\orders has no field or association named designData. My CustomerDesign entity looks like:

/**
* @ORM\ManyToOne(targetEntity="orders", inversedBy="CustomerDesign")
* @ORM\JoinColumn(name="orderID", referencedColumnName="customerID")
*/
protected $orders;

My orders Entity looks like:

/**
* @ORM\OneToMany(targetEntity="orders", mappedBy="CustomerDesign")
*/
protected $CustomerDesign;

How do you handle a complex inner join with Doctrine?

Upvotes: 0

Views: 285

Answers (1)

Richard
Richard

Reputation: 4129

Looks like your one to many annotation on Orders is backwards to me. This should be correct.

/**
* @ORM\OneToMany(targetEntity="CustomerDesign", mappedBy="orders")
*/
protected $CustomerDesign;

Upvotes: 1

Related Questions