Feature #52590
Provide a way to get the Doctrine QueryBuilder
| Status: | New | Start date: | 2013-10-07 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assigned To: | - | % Done: | 0% |
|
| Category: | - | |||
| Target version: | - | |||
| PHP Version: | Complexity: | hard | ||
| Has patch: | No |
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.