Doctrine MaxResults and Subentities

Asked Jul 08 '14 at 14:58

Active Jul 08 '14 at 14:58

Viewed 805 times

I have a query look like this:

$limit = 3;    

$qb = $this->createQueryBuilder('media')
      ->leftJoin('media.file', 'file')
      ->leftJoin('file.meta', 'fileMeta')
      ->addSelect('file')
      ->addSelect('fileMeta');

$qb->setMaxResults($limit);

The limit of the setMaxResults function impact also the Joins and so I don't get all meta of the file. What is the common way to handle a limit only on the main entity?

asked Jul 08 '14 at 14:58

Alexander Schranz

2,154
2
25
42

1

possible duplicate of [Limiting a doctrine query with a fetch-joined collection?](http://stackoverflow.com/questions/5620771/limiting-a-doctrine-query-with-a-fetch-joined-collection) – denys281 Jul 08 '14 at 15:09
thank you it works with the paginator – Alexander Schranz Jul 08 '14 at 15:29

Doctrine MaxResults and Subentities

0 Answers0