Doctrine: Fetch entities by property in array

Question

I have an entity Image which has the property "categories". Categories is an instance of Doctrine's ArrayCollection and holds different Category objects.

I now want to fetch all Image objects containing the Category object "main".

With normal properties this looks like this:

$repository->findBy(array('category' => 'main'));

Is this also possible with Array properties or do I have to fetch the Images over the Category side?

Regards!

Herzult · Accepted Answer · 2012-04-29 19:53:08Z

1

The ->findBy() method only works on the owning side of relations.

You can also create a custom method in your repostiory:

public function findByCategoryName($categoryName)
{
    return $this
        ->createQueryBuilder('image')
        ->innerJoin('image.categories', 'category')
        ->where('category.name = :categoryName')
        ->setParameter('categoryName', $categoryName)
        ->getQuery()
        ->getResult()
    ;
}

edited Apr 29, 2012 at 19:53

answered Apr 29, 2012 at 19:32

Herzult

3,41925 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bodokaiser Over a year ago

Hi, would you self stick to inversing or owning side? Or would you leave out a ManyToMany Category <-> Image relation at all?

Collectives™ on Stack Overflow

Doctrine: Fetch entities by property in array

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related