在Doctrine2查询构建器中链接orX [英] Chaining orX in Doctrine2 query builder

查看:115
本文介绍了在Doctrine2查询构建器中链接orX的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我必须向 getListQueryBuilder 返回的查询构建器动态添加 OR 表达式,然后添加 where 子句。我找不到任何合适的方法,我刚刚开始学习教义。

I have to dynamically add OR expressions to the query builder returned by getListQueryBuilder, right after adding a where clause. I can't find any suitable way of doing this, i'm just started learning Doctrine.

我如何链接给定数量的 orX 并将它们添加到我的构建器中

How can i "chain" a given number of orX and add them to my builder?

public function getListQueryBuilder($ownerId)
{
    $qb = $this->createQueryBuilder('t');

    return $qb
        ->where($qb->expr()->eq('t.user', ':user'))
        ->setParameter('user', $ownerId);
}

$builder = getListQueryBuilder(4);

// $ORs is a dynamically builded array, here is just an example
$ORs = array();
$ORs[] = $builder->expr()->like("t.name", 'my name');
$ORs[] = $builder->expr()->like("t.description", 'desc');

// Adding ORs to the builder
$builder->andWhere($builder->expr()->orX(/* here */));


推荐答案

您可以检查此解决方案

$orX = $builder->expr()->orX();
foreach($ORs as $or) {
    $orX->add($or);
}
$builder->andWhere($orX);

这篇关于在Doctrine2查询构建器中链接orX的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆