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- gt users- gt filter  active    gt  TRUE - gt first     It s unclear for me how the filter method is actually used

User · Answer

The Collection filter method really does eager load all members   Filtering at the SQL level will be added in doctrine 2 3

User · Answer

The Boris Gu  ry answer s at this post  may help you  Doctrine 2  query inside entities   idsToFilter   array 1 2 3 4     member- gt getComments  - gt filter      function  entry  use   idsToFilter           return in array  entry- gt getId     idsToFilter

User · Answer

Your use case would be          ArrayCollectionOfActiveUsers    customer- gt users- gt filter function  user                            return  user- gt getActive       TRUE                            if you add - first   you ll get only the first entry returned  which is not what you want     Sjwdavies You need to put    around the variable you pass to USE  You can also shorten as in array return s a boolean already        member- gt getComments  - gt filter  function  entry  use   idsToFilter            return in array  entry- gt getId     idsToFilter

User · Answer

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  - gt where Criteria  expr  - gt in  id    ids         return  this- gt getComments  - gt matching  criteria

[orm] Doctrine 2 ArrayCollection filter method

Examples related to orm

Examples related to doctrine-orm

Examples related to lazy-loading

Examples related to arraycollection