How to implement column sorting in gridView added from linked table in Yii2?

Question

Yii

How to implement column sorting in a GridView that is added from a related table. All columns are sorted except this one. Please be consistent: what needs to be added to the Controller, what to the Model ..

Answer 1

in the data provider, you need to specify data on how to sort this attribute, for example:

$dataProvider->sort->attributes['author.name'] = [
    'asc' => ['author.name' => SORT_ASC],
    'desc' => ['author.name' => SORT_DESC],
];

but it is worth considering that for sorting, related data must be loaded using joinWith, and not with
PS maybe you should learn to read the documentation or just google , so as not to ask questions that are well described everywhere?

Answer 2

in index.php in GridView
in the example below, the connection with City by the city_id field

[
                'attribute' => 'city_id',
                'filter' => City::find()->select(['name', 'id'])->indexBy('id')->column(),
                'value' => ...
            ]

Answer 3

Specify a property in the search model, and dance from it in search().
Specify this parameter in DataProvider in sort