Doctrine paginator

Question

I'm running into a problem with the Doctrine Paginator.

In my repository I have a function to retrieve a specific dataset. I use the querybuilder for this:

{myEntityRepository}->createQueryBuilder($alias)

In order to select only specific fields I use the following:

if (count($selectFields) > 0) {
    $qb->resetDQLPart('select');
    foreach ($selectFields as $selectField) {
        $qb->addSelect($alias . '.' . $selectField);
    }
}

This works fine when I retrieve the whole set like this:

$query = $qb->getQuery();
$data = $query->getResult(AbstractQuery::HYDRATE_ARRAY);

But it fails when I use the paginator:

$paginator = new Paginator($qb, $fetchJoinCollection = false);
$total = $paginator->count(),
$data = $paginator->getQuery()->getResult(AbstractQuery::HYDRATE_ARRAY)

I get the error:

Not all identifier properties can be found in the ResultSetMapping: relationID
\vendor\doctrine\orm\lib\Doctrine\ORM\Query\Exec\SingleSelectExecutor.php(38)

Question: Why does the paginator fail when I select only specific fields?
Am I overlooking something? Or am I doing it wrong all together?

Semih Sari Semih Sari · Accepted Answer · 2015-02-15T09:21:44

i am using this solution.

add use statements

use Zend\Paginator\Paginator;
use DoctrineORMModule\Paginator\Adapter\DoctrinePaginator as DoctrineAdapter;
use Doctrine\ORM\Tools\Pagination\Paginator as ORMPaginator;

in your action

$viewModel = new ViewModel();

$entityManager = $this->getServiceLocator()
    ->get('Doctrine\ORM\EntityManager');

$queryBuilder = $entityManager
    ->createQueryBuilder();
$queryBuilder->add('select', new Expr\Select(array('t.id', 't.name')));
$queryBuilder->add('from', 'Application\Entity\Table t');

$adapter = new DoctrineAdapter(
    new ORMPaginator(
        $queryBuilder
    )
);
$paginator = new Paginator($adapter);
$paginator->setDefaultItemCountPerPage(20);

$page = (int)$this->params()->fromQuery('page');
if($page) $paginator->setCurrentPageNumber($page);

$viewModel->results = $paginator;

return $viewModel;

Doctrine paginator

2 Answers