How to sort by two related tables in yii2?

Question

Yii

there is such a database, how to sort products in gridView by location name

UPD: the solution, as always, is in the documentation. in this situation, this method will help.
My Code:
Model Products

public function getLocations()
    {
        return $this->hasMany(Locations::className(), ['id' => 'location_id'])
            ->viaTable('product_to_location', ['product_id' => 'id']);
    }

ProductSearch class

$dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
                'pageSize' => 100,
            ],
            'sort' => ['defaultOrder' => ['name' => SORT_ASC],
                'attributes' => [
                    'location' => [
                        'asc' => ['locations.name' => SORT_ASC],  //locations это имя таблицы в БД, а не имя класса или геттера
                        'desc' => ['locations.name' => SORT_DESC],
                    ]
                ]
            ]
        ]);

Answer 1

No to google !
Or so

Answer 2

svg clip path