我有跟随ER,我需要使用查询生成器在Symfony2-Doctrine中执行以下查询(仅在请求特定过滤器时使用连接) @H_419_7@

@H_419_7@

SELECT *
From
  `session`
  INNER JOIN `goal` ON (`session`.`id` = `goal`.`session_id`)
WHERE
  `goal`.`name` = 'Background Dx' AND 
  `session`.`gsITe_id` = '66361836'

@H_419_7@目标宣言

@H_419_7@

/**
....
 *
 * @ORM\Table(name="goal")
 * @ORM\Entity
 */
class Goal
{
    ...
    /**
     * @VAR Session
     *
     * @ORM\ManyToOne(targetEntity="Session")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="session_id",referencedColumnName="id")
     * })
     */
    PRivate $session;
    ...
}

@H_419_7@会话类不包含对目标的任何引用

@H_419_7@通过阅读在线文档,似乎学说要求在实体会话上存在列以执行请求的连接.是真的如此,还是有另一种方式？

@H_419_7@我的QueryBuilder

@H_419_7@

$rep = $this->em->getRepository(Session::repositoryName);
$qb = $rep->createQueryBuilder("s");

$qb->setMaxResults(50);


//site
if ($params->site != null){
    /** @var Gsite **/
    $site = $params->site;
    $qb->andWhere($qb->expr()->eq("s.site",":site"))->setParameter("site",$site);
}
if (isset($params->goalName)){
    ///SOMETHING
    ....
    ...
    ...
}

$query = $qb->getQuery();
$paginator = new Paginator($query);
return $paginator;

$qb->innerJoin('You\YourBundle\Entity\Goal','g',Expr\Join::WITH,'s.id = g.session')
->where('g.name = :goalName')->andWhere('s.gsiteid = :gsiteId')
->setParameter('goalName','Background Dx')->setParameter('gsiteId','66361836');