Project

General

Profile

Actions

Feature #102194

open

Paginator for QueryBuilder

Added by Philipp Kitzberger 9 months ago. Updated 7 months ago.

Status:
Under Review
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2023-10-18
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

Currently there's two Paginators in the core:

  • \TYPO3\CMS\Core\Pagination\ArrayPaginator
  • \TYPO3\CMS\Extbase\Pagination\QueryResultPaginator

Neither of them is ideal for QueryBuilder results, right?

Sure we could use ArrayPaginator like this:

$query = $queryBuilder->select('*')->from('tt_content');
new ArrayPaginator($query->executeQuery()->fetchAll(), $currentPage, $itemsPerPage);

But this will always fire the whole SELECT statement without any LIMIT to the database.

I suggest to add a 3rd paginator to the core: QueryResultPaginator

Actions #1

Updated by Gerrit Code Review 9 months ago

  • Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81447

Actions #2

Updated by Gerrit Code Review 9 months ago

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/81447

Actions #3

Updated by Bastian Stargazer 7 months ago

Will this feature patch also be available in v11? That would be awesome!

Actions

Also available in: Atom PDF