[FIXED] Yii2 : Active Record add Not In condition

Issue

What is the active Record way of adding IN condition to an active Query in yii 1.x you could use CDbCriteria like this

$cr = new CDbCriteria();
$cr->addNotInCondition('attribute', $array);

There seem to be no equivalent API call in yii2 active record implementation, how to do this via active record ?

Solution

Well all query operands seems now merged within in yii\db\QueryInterface::Where() per documentation an In condition can now be added using something like

$query = MyModel::find()->where(['attribute'=>$array]);

for a not In condition it is slightly different format

$query = MyModel::find()->where(['not in','attribute',$array]);

Answered By - Manquer