Yii2 grid view widget sorting in desc order

2
votes

i have a grid view like this 

 <?= GridView::widget([
        'dataProvider' => $dataProvider,
        'columns' => [
            ['class' => 'yii\grid\SerialColumn'],


            'movie.movie_name',
            'start_date',
            'end_date',
            'theatre.theatre_name',
            'screen.screen_name',
            'time.start_time',

            ['class' => 'yii\grid\ActionColumn'],
        ],
    ]); ?>

how can i arrange them in a descending order based on start_date?

1
yii2

1 Answers

10
votes

In search model add sort attribute:

public function search($params)
{
    ...

    $dataProvider = new ActiveDataProvider([
        'query' => $query,
        'sort'=> ['defaultOrder' => ['start_date' => SORT_DESC]]
    ]);
 ....
}