doujiena0025 2017-06-02 09:19
浏览 77
已采纳

在symfony / doctrine中查询not null OneToMany关系

I am using Symfony 3.2. I have an entity called Site which contains a OneToMany relationship to another entity called Indication.

class Site
{
    /**
     * @ORM\OneToMany(targetEntity="IhkBundle\Entity\Indication", mappedBy="site")
     */
    private $indications;
}

class Indication
{
    /**
     * @ORM\ManyToOne(targetEntity="IhkBundle\Entity\Site", inversedBy="indications")
     * @ORM\JoinColumn(name="site_id", referencedColumnName="id")
     */
    private $site;
}

I want to query for all sites where Indications are available. I only get an ArrayCollection which I don't know what to do with.

$sites = $repository->findAll();
foreach ($sites as $site) {
   $site->getIndications();
}

I also tried to use the queryBuilder like in this answer.

$query = $repository->createQueryBuilder('s');
$result = $query->where('s.indications IS NOT NULL')
    ->getQuery()
    ->getResult();

which throws the following error:

[Semantical Error] line 0, col 46 near 'indications IS': Error: Invalid PathExpression. StateFieldPathExpression or SingleValuedAssociationField expected.
  • 写回答

1条回答 默认 最新

  • dongqiongjiong4740 2017-06-02 09:28
    关注

    Seems like this can be solved by SQL by doing a simple join, something like this should work:

    $query = $repository->createQueryBuilder('s');
    $result = $query->select('p')
        ->join('p.indications', 'i')
        ->getQuery()
        ->getResult();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 关于php页面调取、更新数据提交刷新等问题
  • ¥50 使用 java+selenium 接管手动打开的IE浏览器
  • ¥15 ios 新安装app收不到fcm推送
  • ¥15 有没有实力的写手?有过成品的优先
  • ¥15 图像信息库的建立与识别
  • ¥15 韩国网站购物,KG支付的支付回调如何解决
  • ¥15 workstation导入ovf文件,报错,怎么解决呢?
  • ¥15 关于#c语言#的问题:构成555单稳态触发器,采用LED指示灯延时时间,对延时时间进行测量并显示(如楼道声控延时灯)需要Proteus仿真图和C语言代码
  • ¥15 workstation加载centos进入emergency模式,查看日志报警如图,怎样解决呢?
  • ¥50 如何用单纯形法寻优不能精准找不到给定的参数,并联机构误差识别,给定误差有7个?matlab