Maintained
3.0 (upcoming) 2.3 (upcoming) 2.2.2 (current) 1.8.0
Unmaintained
2.1 2.0 1.7 1.6

Expressions

The Doctrine\Common\Collections\Expr\Comparison class can be used to create expressions to be used with the Doctrine\Common\Collections\Criteria class. It has the following operator constants:

  • Comparison::EQ
  • Comparison::NEQ
  • Comparison::LT
  • Comparison::LTE
  • Comparison::GT
  • Comparison::GTE
  • Comparison::IS
  • Comparison::IN
  • Comparison::NIN
  • Comparison::CONTAINS
  • Comparison::MEMBER_OF
  • Comparison::STARTS_WITH
  • Comparison::ENDS_WITH

The Doctrine\Common\Collections\Criteria class has the following API to be used with expressions:

where

Sets the where expression to evaluate when this Criteria is searched for.

1$expr = new Comparison('key', Comparison::EQ, 'value');

$criteria->where($expr);


2


3

andWhere

Appends the where expression to evaluate when this Criteria is searched for using an AND with previous expression.

1$expr = new Comparison('key', Comparison::EQ, 'value');

$criteria->andWhere($expr);


2


3

orWhere

Appends the where expression to evaluate when this Criteria is searched for using an OR with previous expression.

1$expr1 = new Comparison('key', Comparison::EQ, 'value1');
$expr2 = new Comparison('key', Comparison::EQ, 'value2');

$criteria->where($expr1);
$criteria->orWhere($expr2);


2


3


4


5

orderBy

Sets the ordering of the result of this Criteria.

1$criteria->orderBy(['name' => Criteria::ASC]);

setFirstResult

Set the number of first result that this Criteria should return.

1$criteria->setFirstResult(0);

getFirstResult

Gets the current first result option of this Criteria.

1$criteria->setFirstResult(10);

echo $criteria->getFirstResult(); // 10


2


3

setMaxResults

Sets the max results that this Criteria should return.

1$criteria->setMaxResults(20);

getMaxResults

Gets the current max results option of this Criteria.

1$criteria->setMaxResults(20);

echo $criteria->getMaxResults(); // 20


2


3