Set LIMIT with doctrine 2

Question

I trying to write a query  with subquery  but i don t know how set a limit in my subquery  My query    query ids    this- gt getEntityManager         - gt createQuery           SELECT e  id         FROM MuzichCoreBundle Element e          WHERE               GROUP BY e  id        - gt setMaxResults 5          query select    SELECT e       FROM MuzichCoreBundle Element e        WHERE e id IN     query ids- gt getDql            ORDER BY e created DESC  e name DESC          query    this- gt getEntityManager         - gt createQuery  query select        - gt setParameters  params          But - setMaxResults 5  doesn t work  No  LIMIT  in the SQL query  Can we do simple LIMIT with doctrine 2

User · Answer

qb    this- gt getDoctrine  - gt getManager  - gt createQueryBuilder        qb- gt select  p   - gt from  Pandora UserBundle Entity PhoneNumber    p     qb- gt where  p number    number     qb- gt OrWhere  p validatedNumber  number     qb- gt setMaxResults 1    qb- gt setParameter  number   postParams  From       result    qb- gt getQuery  - gt getResult      data  result 0

User · Answer

Your setMaxResults  limit  needs to be set on the object   e g     query ids    this- gt getEntityManager     - gt createQuery       SELECT e  id     FROM MuzichCoreBundle Element e      WHERE           GROUP BY e  id      query ids- gt setMaxResults  limit

User · Answer

I use  Doctrine ORM Tools Pagination Paginator for this  and it works perfectly  doctrine 2 2        dql    SELECT p  c FROM BlogPost p JOIN p comments c    query    entityManager- gt createQuery  dql                         - gt setFirstResult 0                         - gt setMaxResults 10     paginator   new Paginator  query   fetchJoinCollection   true

User · Answer

query ids    this- gt getEntityManager         - gt createQuery           SELECT e  id         FROM MuzichCoreBundle Element e          WHERE               GROUP BY e  id        - gt setMaxResults 5       - gt setMaxResults  limit           HERE in the second query the result of the first query should be passed      query select    SELECT e       FROM MuzichCoreBundle Element e        WHERE e id IN     query ids- gt getResult            ORDER BY e created DESC  e name DESC           query    this- gt getEntityManager         - gt createQuery  query select        - gt setParameters  params        - gt setMaxResults  limit           resultCollection    query- gt getResult

User · Answer

limit 5     for exemple   query    this- gt getDoctrine  - gt getEntityManager  - gt createQuery                 your request    - gt setMaxResults  limit      results    query- gt getResult        Done

[doctrine-orm] Set LIMIT with doctrine 2?

Examples related to doctrine-orm