Feature #52590

Provide a way to get the Doctrine QueryBuilder

Added by Philipp Maier almost 8 years ago. Updated almost 8 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2013-10-07
Due date:
% Done:

0%

Estimated time:
PHP Version:
Has patch:
No
Complexity:
hard

Description

Currently it is not possible to paginate object collections that require a join to be reconstructed.

If your query contains a fetch-joined collection specifying the result limit methods are not working as you would expect. Set Max Results restricts the number of database result rows, however in the case of fetch-joined collections one root entity might appear in many rows, effectively hydrating less than the specified number of results.

The solution is to use the Paginator that Doctrine provides. Unfortunately this one requires the QueryBuilder as constructor argument.
http://stackoverflow.com/questions/5620771/limiting-a-doctrine-query-with-a-fetch-joined-collection

Once available, the Pagination Widget from Fluid must/should use the Paginator.

No data to display

Also available in: Atom PDF