How to form an ActiveQuery YII2 query?

Question

Yii

I need to organize a request like:

SELECT * FROM table WHERE pole=value AND (pole1=value1 OR pole2=value2)

Not quite sure how to do this with andFilterWhere and orFilterWhere.

Answer 1

Table::find()->where(['and', 'pole=value', ['or', 'pole1=value1', 'pole2=value2']])->findAll()

Answer 2

Possible variant:

$query->where('pole = :value and (pole1 = :value1 or pole2 = :value2)');
$query->params([':value'=>"value", ':value1' => 'value1', ':value2' => 'value2']);

It is also possible to write something like this:

$query->params([':value'=>"value", ':value1' => 'value1', ':value2' => 'value2']);
$query->Where(['and', 'value = :value', ['or', 'value1 = :value1', 'value2 = :value2']]);

Operator Format in Query Builder