Yii2 in grid view to make a text filter on the associated field?

Question

Yii

Made a connection in the model. In grdiview the data comes from the linked table but there is no filter. How to make a filter appear?

[
            'label' => 'Полное имя',
            'attribute'=>'fullname',
            'filter'=>workers::getFullname(),
            'format' => 'text',
            'value' => 'workerInfo.fullname',
        	],

Answer 1

Solved the problem
If you need a dropdownlist, then do the following
In the model, add a link

public function getWorkerInfo()
  {
    	return $this->hasOne(workersInfo::className(), ['userid' => 'userid']);
  }

Then in the grid
'columns' => [
['class' => 'yii\grid\SerialColumn'],
'id',
'userid',
'login',
[
'label' => 'Full name',
'attribute' =>'fullname',
'value' => 'workerInfo.fullname',
'format' => 'text',
// esli nujen select
'filter'=>workersInfo::find()->select(['fullname' , 'fullname'])->indexBy('fullname')->column(),
],
['class' => 'yii\grid\ActionColumn'],
],
If just a text field,
then remove the filter
and in the Search model
1) add a field to the rules
2) public function search($params)
{
$query = workers::find();
$query->joinWith(['workerInfo']);
3) $query->andFilterWhere(['like', 'login', $this->login])
->andFilterWhere(['like', 'workers_info.fullname', $this->fullname]);

Answer 2

YII2: SORT AND FILTER GRIDVIEW BY RELATED AND ...