Doctrine 2 ArrayCollection filter method

Question

Can I filter out results from an arrayCollection in Doctrine 2 while using lazy loading? For example,

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

It's unclear for me how the filter method is actually used.

Answer 1

Doctrine now has Criteria which offers a single API for filtering collections with SQL and in PHP, depending on the context.

https://www.doctrine-project.org/projects/doctrine-orm/en/latest/reference/working-with-associations.html#filtering-collections

Update

This will achieve 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 2

The Boris Guéry answer's at this post, may help you: Doctrine 2, query inside entities

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