Doctrine 2 ArrayCollection filter method

by

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); 
  }
}

More Related Contents:

  1. What is the difference between fetch=”EAGER” and fetch=”LAZY” in doctrine
  2. Memory leaks Symfony2 Doctrine2 / exceed memory limit
  3. What is the “N+1 selects problem” in ORM (Object-Relational Mapping)?
  4. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  5. How to fix org.hibernate.LazyInitializationException – could not initialize proxy – no Session
  6. What is lazy loading in Hibernate?
  7. How do I map lists of nested objects with Dapper
  8. Default value in Doctrine
  9. What are the advantages of using an ORM? [closed]
  10. The EntityManager is closed
  11. Eager , Lazy and explicit loading in EF6
  12. Dapper.Rainbow VS Dapper.Contrib
  13. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  14. What is an Object-Relational Mapping Framework? [duplicate]
  15. Entity framework linq query Include() multiple children entities
  16. JPQL Create new Object In Select Statement – avoid or embrace?
  17. How to map a PostgreSQL array with Hibernate
  18. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  19. On delete cascade with doctrine2
  20. JPA/Hibernate Native Queries do not recognize Parameters
  21. Difference Between One-to-Many, Many-to-One and Many-to-Many?
  22. How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?
  23. Efficiently updating database using SQLAlchemy ORM
  24. Too much data with var_dump in symfony2 doctrine2
  25. symfony2: how to use group_concat in QueryBuilder
  26. Combining LazyLoad and Jquery Masonry
  27. How to make an Inner Join in django?
  28. Doctrine query builder using inner join with conditions
  29. Can I access discriminator field from php in doctrine2?
  30. Could not build ClassFile – ArchiveException

Leave a Comment