By Default Sort Desc Instead Of Asc In Cgridview

amirmohamad · October 26, 2013, 7:13am

Hi all,

as you know cgridview sort a column ASC in first and in second click, sort will change to DESC.

I want to reverse that,

I want first click, sort the column DESC and second click, sort the column ASC.

how?

thanks

le_top · October 28, 2013, 12:57am

See http://www.yiiframework.com/forum/index.php/topic/48310-default-order-in-csort/page__gopid__225859#entry225859 - this person has som issues, but the example should inspire you.

Nurbek · February 16, 2015, 10:37am

Hi, Brother, I am glad to help you.

You need to set in your dataprovider, exactly in sort options set this

    'dataProvider'=&gt;new CActiveDataProvider('SomeModel', array(


            'sort'=&gt;array(


                'attributes'=&gt;array(


                    'someField'=&gt;array(


                        'default'=&gt;'desc',


                    ),


                ),


            ),


        )),

Hope you will thank me.

Nurbek Nurjanov, Yii developer

yatinmistry5130 · February 17, 2015, 4:40am

Use in your model,


return new CActiveDataProvider($this, array(

			'criteria'=>$criteria,

                        'sort'=>array("defaultOrder"=>"task_id DESC")

		));