CODEWITHSUNDEEP
phpyii2yii2-user
Nisarg
Nisarg

Reputation: 85

yii2 + join query in ActiveDataProvider

This is my actual query - 

$dataProvider = new ActiveDataProvider([
            'query' => UserProfile::find()->with(['user'])
        ]);

'status' field is exist in user table. So I want to filter data by where status != 0 but it fails.

I tried this -

1

$dataProvider = new ActiveDataProvider([
            'query' => UserProfile::find()->with(['user'])->where('user.status !=',0)
        ]);

2

$dataProvider = new ActiveDataProvider([
            'query' => UserProfile::find()->with(['user'])->where('<>','user.status',0)
        ]);

None of it works. please let me how its possible?

Upvotes: 5

Views: 6608

Answers (1)

GAMITG
GAMITG

Reputation: 3818

You need change your $dataProvider code with this code.

$dataProvider = new ActiveDataProvider([
            'query' => UserProfile::find()->joinWith(['user(relation_name)'])->where(['<>','user.status',0])
        ]);

Upvotes: 3

Related Questions