Paginate Query with Group By in CakePHP

Paginate Query with Group By in CakePHP

Example Code:

<?php
class PermissionsController extends AppController {
var $name = 'Permissions';
var $uses = array('Permission');
var $helpers = array('Paginator','General');
var $components = array('Auth','Session','Cookie');
var $paginate = array();
function beforeFilter(){
parent::beforeFilter();
}

function index(){
$this->layout = 'admin';
$this->paginate = array(                  //Here is used
'Permission' => array(
'group' => array('group_name'),
'order' => array('id' => 'asc'),
)
      );
$permission = $this->paginate('Permission');
$this->set('permission',$permission);
}
}

?>