yii2 + join query in ActiveDataProvider

Question

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?

GAMITG · Accepted Answer · 2015-09-14T10:54:45.947

3

You need change your $dataProvider code with this code.

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

edited Sep 14 '15 at 10:54

answered Sep 14 '15 at 10:40

GAMITG

3,810
7
32
51

1

I have add array in `where` function. – GAMITG Sep 14 '15 at 10:44
1

I got this error - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.status' in 'where clause' The SQL being executed was: SELECT COUNT(*) FROM `user_profile` WHERE `user`.`status` <> 0 – Nisarg Sep 14 '15 at 10:50
in `with()` `user` is relation name? – GAMITG Sep 14 '15 at 10:52
Yes. UserProfile has relation with User. like this - user_profile.user_id = user.id – Nisarg Sep 14 '15 at 10:55

yii2 + join query in ActiveDataProvider

1 Answers1