Limiting a doctrine query with a fetch-joined collection?

by

Paginate was merged with doctrine 2.2 And the new symfony2 release 2.0.10 is compatible with.

Now use it like that

//use Doctrine paginator
use Doctrine\ORM\Tools\Pagination\Paginator;

Write your query then call results like that.

$query->setMaxResults($limit);
$query->setFirstResult($offset);
$results = new Paginator($query, $fetchJoin = true);

Hope this will help you.

Note: If you are using SF2 2.0.10, you should update the deps and deps.lock files and specify the 2.2 version for Doctrine bundles.

More Related Contents:

  1. Use a DATE() function in a WHERE clause with DQL
  2. Explicitly set Id with Doctrine when using “AUTO” strategy
  3. How to limit items from for loop?
  4. Why does the 260 character path length limit exist in Windows?
  5. How many files can I put in a directory?
  6. LIMIT 10..20 in SQL Server
  7. LIMIT keyword on MySQL with prepared statement [duplicate]
  8. Can HTTP POST be limitless?
  9. Pagination using MySQL LIMIT, OFFSET
  10. Sqlite LIMIT / OFFSET query
  11. Does C++ limit recursion depth?
  12. Cursor size limit in Android SQLiteDatabase
  13. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  14. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  15. Generating a single Entity from existing database using symfony2 and doctrine
  16. Symfony error The class XXX was not found in the chain configured namespaces XXX
  17. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  18. Mysql delete statement with limit
  19. Script runtime execution time limit
  20. Symfony2 and Doctrine – Error: Invalid PathExpression. Must be a StateFieldPathExpression
  21. How to programmatically limit bandwidth usage of my c# application?
  22. JPA 2 CriteriaQuery, using a limit
  23. UPDATE with ORDER BY and LIMIT not working in MYSQL
  24. Upper limit in Python time.sleep()?
  25. Rails 3.1 limit user created objects
  26. Prevent PHP script from being flooded
  27. Check the open FD limit for a given process in Linux
  28. Limiting results in MongoDB but still getting the full count?
  29. MongoDB Single Document size limit is 16MB
  30. “Max open files” for working process

Leave a Comment