Hi, I need to use PHQL query, but I also want to use pagination.
$phql = "SELECT p.* FROM Models\Products AS p "; $products = \Phalcon\DI::getDefault()->get('modelsManager')->createQuery($phql);
doesn't work like that
$paginator = new Phalcon\Paginator\Adapter\QueryBuilder ( [ 'builder' => $productsData, 'limit' => $limit, 'page' => $page, ] );
Is it possible? any thoughts?