Doctrine2 Mongodb adding more $or operator
It is possible for doctrine2 ODM to create the following query?
db.Product.find({ "$or": [ { "name": new RegExp("test*", "i") }, { "tags"开发者_如何学JAVA: new RegExp("public true*", "i") } ], "$or": [{ "public": false, "_id": { "$in": [ ObjectId("4e74121c4fcfa9ff7ac90000"), ObjectId("4e74121c4fcfa9ff7ac80000") ] } }, { "public": true }] });
The main issue here with doctrine2 that I dont understand is how to add addition $or in the $query?
This help me with $and operator which is still missing.
I'm currently using Symfony2 Doctrine2 Mongodb
/**
* Adds an "or" expression to the current query.
*
* You can create the expression using the expr() method:
*
* $qb = $this->createQueryBuilder('User');
* $qb
* ->addOr($qb->expr()->field('first_name')->equals('Kris'))
* ->addOr($qb->expr()->field('first_name')->equals('Chris'));
*
* @param array|QueryBuilder $expression
* @return Builder
*/
/**
* Adds an "and" expression to the current query.
*
* You can create the expression using the expr() method:
*
* $qb = $this->createQueryBuilder('User');
* $qb
* ->addAnd($qb->expr()->field('first_name')->equals('Kris'))
* ->addAnd($qb->expr()->field('first_name')->equals('Chris'));
*
* @param array|QueryBuilder $expression
* @return Query
*/
A small example in addition to theory:
Query in meta-language
:
<condition1> AND (<field1 == value1> OR <field2 == value2>)
Query with Doctrine's QueryBuilder
:
$queryBuilder
->addAnd(<condition1>)
->addAnd(
$queryBuilder
->expr()
->addOr(
$queryBuilder
->expr()
->field('field1')
->equals('value1')
)->addOr(
$queryBuilder
->expr()
->field('field2')
->equals('value2')
)
);
精彩评论