2016-07-04 12:28
浏览 58

Symfony Doctrine查询多对多关系

I have Many to Many relationship between Institutes and Courses. I want to build query that returns only the institutes list whom some courses has been assigned. I have wrote queries in this situation for one to many. but for not many to many. here is the relationships,

class Institutes { 

     * @ORM\ManyToMany(targetEntity="Courses", inversedBy="institutes")
     * @ORM\JoinTable(name="institute_courses",
     *      joinColumns={@ORM\JoinColumn(name="institute_id", referencedColumnName="id")},
     *      inverseJoinColumns={@ORM\JoinColumn(name="course_id", referencedColumnName="id")}
     *      )
    protected $courses;

class Courses {

     * @ORM\ManyToMany(targetEntity="Institutes", mappedBy="courses")
    protected $institutes;

here is the query that i have written, but didn't work properly.

                        ->leftJoin('CoursesBundle:Courses','c', 'ON c.institutes = s.courses')
                        ->where('s.active = :active')
                        ->andWhere('s.verified = :active')
                        ->setParameter('active', true)
                        ->orderBy('s.name', 'ASC');
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

2条回答 默认 最新

  • dty98339 2016-07-04 16:00

    This should do the trick:

        ->where('i.active = TRUE')
        ->andWhere('i.verified = TRUE')
        ->orderBy('i.name', 'ASC');
    解决 无用
    打赏 举报

相关推荐 更多相似问题