How to do Sorting in CActiveDataProvider in YII?

Question

I write this but it doesn't do any effect in views.

$dataProvider=new CActiveDataProvider('Example', array(
  'sort'=>array(
    'defaultOrder'=>'title ASC',
  )
));

Is any changes in view needed ?

Nope, no change to the view is necessary. Did you try switching it up, maybe it was already sorted like that- try putting title DESC. — peaceman, Apr 08 '16 at 14:26

score 1 · Answer 1 · answered Apr 18 '16 at 05:25

Example Code:

$criteria=new CDbCriteria;
$criteria->compare('display_order',$this->display_order);
$sort = new CSort();
$sort->defaultOrder=array('display_order' => CSort::SORT_DESC);
return new CActiveDataProvider($this, array(
    'pagination'=>array(
        'pageSize'=>10,
     ),
    'sort'=>$sort,
    'criteria'=>$criteria,
));

score 0 · Answer 2 · answered Apr 10 '16 at 11:14

0

Try this..

'defaultOrder'=>array('title'=>CSort::SORT_ASC)

answered Apr 10 '16 at 11:14

Nahian Khondoker

367
1
6

How to do Sorting in CActiveDataProvider in YII?

2 Answers2