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 ?

Answer 1

Try this..

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

Answer 2

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,
));