Chaining orX in Doctrine2 query builder

doctrine, doctrine-orm, mysql, sql

Solution

You can check this solution:

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

Problem

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. 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 */)); ```

Original source