PHP, Yii2 GridView filtering on relational value

Question

Following on from this: Yii2 how does search() in SearchModel work? I would like to be able to filter a `GridView` column of relational data. This is what I mean: I have two tables, `TableA` and `TableB`. Both have corresponding models generated using Gii. `TableA` has a foreign key to a value in `TableB`, like this: ``` TableA attrA1, attrA2, attrA3, TableB.attrB1 TableB attrB1, attrB2, attrB3 ``` attrA1 and attrB1 are the primary keys of their corresponding tables. Now, I have a Yii2 `GridView` of `attrA2`, `attrA3` and `attrB2`. I have a working filter on `attrA2` and `attrA3` so that I can search on column values. I also have a working sort for these two columns too - by just clicking on the column header. I would like to be able to add this filtering and sorting on `attrB2` too. My `TableASearch` model looks like this: ``` public function search($params){ $query = TableA::find(); $dataProvider = new ActiveDataProvider([ 'query' => $query, ]); if (!($this->load($params) && $this->…

Accepted Answer

Filtering a gridview by a column is damn easy in Yii 2.0. Please add the filter attribute to a gridview column having lookup values, as under:

```
[
        "class" => yii\grid\DataColumn::className(),
        "attribute" => "status_id",
        'filter' => ArrayHelper::map(Status::find()->orderBy('name')->asArray()->all(), 'id', 'name'),
        "value" => function($model){
            if ($rel = $model->getStatus()->one()) {
                return yii\helpers\Html::a($rel->name,["crud/status/view", 'id' => $rel->id,],["data-pjax"=>0]);
            } else {
                return '';
            }
        },
        "format" => "raw",
], 
```

PHP, Yii2 GridView filtering on relational value

Solution

Problem

Related problems