pass array of conditions to doctrine expr()->orx() method

user_1169194 0
Viewed 28494

I need to construct DQL with a QueryBuilder like this 

[QUERY]... AND WHERE e.type = x OR e.type = Y OR e.type = N [...]

I have types in array How can I pass this array to my query builder? 

$qb->andWhere($qb->expr()->orx(CONDITIONS));

List of types will be dynamic, calling $qb->andWhere on each foreach types loop will make only more AND WHERE's no more ORs.
Can I store multiply orx expressions and then add it to andWhere? Any idea how to solve this, probably, common problem?

doctrine-orm dql doctrine oop php
5 Answers

You can also use ... in php like:

$conditions = array('e.type = x', 'e.type = Y', 'e.type = N');
$criteria = Criteria::create();
$criteria->andWhere(Criteria::expr()->orX(...$conditions));
user_43633870
Related