How to do a default sort on cgridview

Yii 1.1 General Discussion
1

hi,

i have the following cgrid view


[size=2]$this->widget('zii.widgets.grid.CGridView', array([/size]

	'id'=>'complaint-job-grid',

	'dataProvider'=>$model->search($complaint),

	//~ 'filter'=>$model,

	'columns'=>$columns,

	'enableSorting'=>true,

	

	

	

	//~ 'ajaxUpdate'=>false,

[size=2]));[/size]

my model code is





public function search($complaint)

	{

		// @todo Please modify the following code to remove attributes that should not be searched.


		$criteria=new CDbCriteria;

		$criteria->with	=	array('complaint_job','user');

		

		$criteria->compare('complaint_job.job_desc',$this->job_search, true);

		if($this->user_search)

			$criteria->addSearchCondition('CONCAT(first_name," ",last_name)', $this->user_search);

		$criteria->compare('complaint_id',$complaint);

		$criteria->compare('id',$this->id);

		$criteria->compare('job_id',$this->job_id);

		$criteria->compare('local_description',$this->local_description,true);

		$criteria->compare('employee_id',$this->employee_id);

		$criteria->order = 't.id ASC';

		return new CActiveDataProvider($this, array(

			'criteria'=>$criteria,

		));

	}

so what i basically want is to show values in the cgridview in descending order of id(primary key). is it possible?

2

This is what U need:




  return new CActiveDataProvider($this, array(

  'criteria' => $criteria

  'sort'=>array(

    'defaultOrder'=>'title ASC',

  )

));
1 Like