Symfony2, PagerFanta results

I will Do the query

$array = $query->getResult(Query::HYDRATE_ARRAY);

Use the ArrayAdapter

$adapter = new ArrayAdapter($array);$pagerfanta = new Pagerfanta($adapter);

symfony doctrine pagerfanta

You must to set hydratation mode to Query from the adapter:

$adapter = new DoctrineORMAdapter($queryBuilder);$adapter->getQuery()->setHydrationMode(Query::HYDRATE_ARRAY);$pager = new Pagerfanta($adapter);

CodeHunter