Yii2 : Active Record add Not In condition

Question

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 ?

Answer 1

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]); 

Answer 2

$query = MyModel::findAll(['not in ','attribute',$array]); 

http://www.yiiframework.com/doc-2.0/guide-db-active-record.html