Thanks you all.
I did find a way to do my request with out calling the paginator using only
QueryBuilder and EntityManager.
So I still do this :
$qb = $this->em->createQueryBuilder();
$qb->select('q', 'sc', 'd')
->from('ECT\Entity\entity', 'q')
->innerJoin('q.entity2', 'sc')
->innerJoin('q.entity3', 'd');
$qb->getQuery();
But then, I only do $qb->getResult();
No Pagination, No FirstResult nor MaxResult.
Thank you very much.
Le mardi 26 janvier 2016 21:00:40 UTC+1, Christophe COEVOET a écrit :
>
> Le 26/01/2016 15:16, Pat Tryçias a écrit :
> > Why Doctrine don't use thoses methode ?
> > ->setFirstResult($offset)
> > ->setMaxResults($itemCountPerPage);
> >
> > To me, pagination should not use a IN over an id list.
> >
> It uses them when you tell the paginator that there is no collection
> field being fetch joined in the DQL query. But by default, it cannot
> make this assumption, and using them would break the result when there
> is a collection being fetched joined (as a single entity in the results
> would require multiple rows in the SQL results)
>
> --
> Christophe | Stof
>
>
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
