Doctrine2 association mapping with conditions

by

You can use the Criteria API to filter the collection:

<?php

use Doctrine\Common\Collections\Criteria;

class Article
{

    /**
     * @ORM\OneToMany(targetEntity="Comment", mappedBy="article")
     */
    protected $comments;

    public function getComments($showPending = false)
    {
        $criteria = Criteria::create();
        if ($showPending !== true) {
            $criteria->where(Criteria::expr()->eq('approved', true));
        }
        return $this->comments->matching($criteria);
    }

}

This is especially nice, because Doctrine is smart enough to only go to the database if the collection hasn’t already been loaded.

More Related Contents:

  1. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  2. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  3. On delete cascade with doctrine2
  4. Why I am suddenly getting a “Typed property must not be accessed before initialization” error when introducing properties type hints?
  5. How to do left join in Doctrine?
  6. Default value in Doctrine
  7. Doctrine 2 and Many-to-many link table with an extra field
  8. How to use WHERE IN with Doctrine 2
  9. How to select randomly with doctrine
  10. Should I use EAV model?
  11. Select entries between dates in doctrine 2
  12. Too much data with var_dump in symfony2 doctrine2
  13. How to re-save the entity as another row in Doctrine 2
  14. Subquery in doctrine2 notIN Function
  15. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  16. How to set up entity (doctrine) for database view in Symfony 2
  17. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  18. How to get a one-dimensional scalar array as a doctrine dql query result?
  19. How to setup table prefix in symfony2
  20. How to use a findBy method with comparative criteria
  21. Symfony 2.0 getting service inside entity
  22. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  23. Can I access discriminator field from php in doctrine2?
  24. How to force Doctrine to update array type fields?
  25. Query on a many-to-many relationship using Doctrine with Symfony2
  26. How can I use DATE() in Doctrine 2 DQL?
  27. Join subquery with doctrine 2 DBAL
  28. How can I set text value of SimpleXmlElement without using its parent?
  29. Setting PHP tmp dir – PHP upload not working
  30. php integer and float comparison mismatch

Leave a Comment