Yii2 : Active Record add Not In condition

activerecord yii yii2
Manquer picture Manquer · Sep 20, 2014 · Viewed 66.9k times · Source

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

Manquer picture Manquer · Sep 20, 2014

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

Related questions

Yii2 How to perform where AND or OR condition grouping?

I am new to Yii-2 framework. How can i achieve following query in Yii-2 framework using activeQuery and models. SELECT * FROM users AS u WHERE u.user_id IN(1,5,8) AND (u.status = 1 OR u.verified = 1) OR (u.social_account = 1 AND …

Read More
How to do IS NULL and IS NOT NULL with Yii 2 ActiveRecord?

I have a table which has a field `activated_at` timestamp NULL DEFAULT NULL, which means that it can contain a timestamp or it can be null and it's null by default. I have another [gii-generated] search model with a …

Read More
Yii selecting only specified attributes in array

I often face this problem.. Lets say ..In blog application, I need to email all the active users.. What I do is write findAll on users with some conditions of their last login being greater than some value..and get …

Read More