What am I doing wrong when searching through related tables?

Question

Yii

There is a Car model with a link to the brand by brand-id:

public function getBrand()
  {
    return $this->hasOne(Brand::className(), [
      'id' => 'brand_id'
    ]);
  }

This brand has a name field . And to search by the name
field , I do this:

$query->joinWith('brand');
$query->orFilterWhere([
  'like', 'brand.name', '%'.$this->company.'%', false
]);

(search by company field )
The code doesn't work. What am I doing wrong. If that the Brand model table is called car_brand

Answer 1

1. You now have the name of the model, but the name of the table should be
2. The characters '%' Yii sets itself

$query->orFilterWhere([
  'like', 'car_brand.name', $this->company
]);