CActiveDataProvider, sort defaultOrder with multiple columns

Yii 1.1 General Discussion
1

Hi, is it possible to add a secondary sorting column using defaultOrder in CActiveDataProvider?

In my model i currently have this:




return new ActiveDataProvider($this, array(

	'criteria' => $criteria,

	'sort' => array(

                'defaultOrder' => array(

      			'date' => true // Would be nice to add something like this here: 'date, id' => true

    		)

        ),

        'pagination' => array(

        	'pageSize' => 20

    	),

));

Thanks!

2

you can specify:




'sort' => array(

                'defaultOrder' => array(

                        'date' => true,

                        'id' => false

                )

        ),

or




'sort' => array(

                'defaultOrder' => 'date DESC, id ASC',

        ),
3

what U need is :

‘sort’ => array(

            'defaultOrder' => 'date DESC, id ASC',


    ),
1 Like
4

Thanks for the help, adding ‘id’ => false did the trick :)