Doctrine 2 ArrayCollection Filter Method

Question

Can I filter results from an array in Doctrine 2 when using lazy loading? For example,

// users = ArrayCollection with User entities containing an "active" property $customer->users->filter('active' => TRUE)->first() 

It is unclear how the filter method is used.

Answer 1

Boris Gehry's answer on this post may help you: Doctrine 2, request inside objects

 $idsToFilter = array(1,2,3,4); $member->getComments()->filter( function($entry) use ($idsToFilter) { return in_array($entry->getId(), $idsToFilter); } ); 

Answer 2

Doctrine now has Criteria , which offers one API for filtering collections with SQL and PHP, depending on context.

http://docs.doctrine-project.org/en/latest/reference/working-with-associations.html#filtering-collections

Update

This will produce the result in the accepted answer without getting everything from the database.

 use Doctrine\Common\Collections\Criteria; /** * @ORM\Entity */ class Member { // ... public function getCommentsFiltered($ids) { $criteria = Criteria::create()->where(Criteria::expr()->in("id", $ids)); return $this->getComments()->matching($criteria); } } 

Answer 3

Your use case:

  $ArrayCollectionOfActiveUsers = $customer->users->filter(function($user) { return $user->getActive() === TRUE; }); 

if you add → first (), you will only get the first entry entered, which is not what you want.

@Sjwdavies You need to put () around the variable you pass to the USE. You can also shorten since in_array already returns a boolean:

  $member->getComments()->filter( function($entry) use ($idsToFilter) { return in_array($entry->getId(), $idsToFilter); }); 

Answer 4

The Collection#filter method really loads all members. SQL-level filtering will be added to Doctrine 2.3.