Disable sorting in header column of Yii CGridView

Question

Yii provides sorting functionality for listing. How can I disable sorting so that my records will not get sorted when clicked on column header?

score 23 · Accepted Answer · answered Oct 01 '12 at 06:43

23

set 'enableSorting' => false in your list/gridview definition.

$this->widget('zii.widgets.CListView', array(
        ......
        'enableSorting' => false,
        ......
    )
);

answered Oct 01 '12 at 06:43

SuVeRa

2,784
2
20
27

score 0 · Answer 2 · edited Dec 17 '14 at 10:31

0

When Bootstrap is used you can disable sorting by using below syntax -

$this->widget('bootstrap.widgets.TbExtendedGridView',
  array(
         ......
         'enableSorting' => false, //tag for sorting - true or false
         .........
  ));

edited Dec 17 '14 at 10:31

Rohit Suthar

3,528
1
42
48

answered Sep 19 '14 at 07:08

Snopzer

1,602
19
31

score 0 · Answer 3 · edited Jul 26 '18 at 13:06

If you use GridView

Then you can do that:

$dataProvider =  new yii\data\ActiveDataProvider([
        'sort'=>false,
    'query' => **some query here**
]);

or if you want to sort certain columns:

$dataProvider =  new yii\data\ActiveDataProvider([
            'sort'=>['attribute'=>[**attribute names here**]],
        'query' => **some query here**
    ]);

and then use this data provider in your GridView widget:

<?= GridView::widget([
     'dataProvider'=>$dataProvider,
      ...
]) ?>

Disable sorting in header column of Yii CGridView

3 Answers3