CODEWITHSUNDEEP
symfonyfilterone-to-manycriteria
bamalu
bamalu

Reputation: 25

Symfony2 Criteria filtering OneToMany

I have an Entity called 'User', which has a OnetoMany relation in a field called 'books'.

I also have an Entity called 'Book' which has many attributes, like, 'title' or 'date'.

There ir another entity called 'Date', which attributes are: 'day', 'month' and 'year'.

I want to filter the books that the user has which are from year 2009.

I am tring to do it like this, using Criteria, but I recieve an error because field date.year does not exist:

$books = $user->getBooks(); 

$criteria = Criteria::create()
            ->where(Criteria::expr()->eq("date.year", "2009"));

$books_2009 = $books->matching($criteria);

Any idea of how can I solve it?

Upvotes: 0

Views: 648

Answers (1)

tomazahlin
tomazahlin

Reputation: 2167

$criteria = Criteria::create()
        ->where(Criteria::expr()->eq("year", "2009"));

This should work. Please let me know.

Upvotes: 1

Related Questions