There were a typo in my message.
sorry
Le mercredi 27 janvier 2016 11:55:36 UTC+1, Pat Tryçias a écrit :
>
> 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');
> *$query *= $qb->getQuery();
> But then, I only do *$query*->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.
