Yii CGrid pagination and sorting with CArrayDataProvider doesnt work

Yii 1.1 General Discussion
1

I built a custom function in my model and return the raw data:


function(){

...

$connection=Yii::app()->db;

$command=$connection->createCommand($sql);

$rows=$command->queryAll();

return $rows;

}

$campModel = $model->function..

I then use those rows in CArrayDataProvider:

$dataProvider=new CArrayDataProvider($campModel);

Finally i’m trying to view using CGrid:


$this->widget('zii.widgets.grid.CGridView', array(

'id'=>'bo-campaigns-grid',

'dataProvider'=>$campModel,...

I’m guessing this has to do with the way CGrid is paging…but i’m lost Thanks for the help :)

2

Try this:





$dataProvider = new CArrayDataProvider($campModel, array(

   'sort' => array(

      'attributes' => array('id', 'title'); //What you want to sort ?

      'defaultOrder' => array('title' => false); //false means ASC

    ),

    'pagination' => array(

        'pageSize' => 5;

     ),


));