user6175355
user6175355

Reputation:

How to do Sorting in CActiveDataProvider in YII?

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 ?

Upvotes: 1

Views: 1504

Answers (2)

Ram Pukar
Ram Pukar

Reputation: 1621

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

Upvotes: 1

Nahian Khondoker
Nahian Khondoker

Reputation: 367

Try this..

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

Upvotes: 0

Related Questions