how to use subquery inside select statement of yii2

Question

I have a query as below.

 $subQuery = (new Query())->select('is_approved')->from('user_requests')->where(['user_ref_id' => yii::$app->user->id])->andWhere(['AND','project_ref_id = p.project_id']);

This is the subquery which I am trying to call in select statement as below

 $Query = (new Query())->select(['project_id','IF(p.project_type_ref_id = 2, '.$subQuery.', "" ) AS project_request_id'])
                             ->from('projects AS p');

If I try to execute the query I am getting below error in the line where I added $subQuery

PHP Recoverable Error – yii\base\ErrorException
Object of class yii\db\Query could not be converted to string

How to add a subquery in select statement. Please help. Thanks in advance !!

Possible duplicate of [How to pass subquery as table name to another query in yii2](https://stackoverflow.com/questions/48680018/how-to-pass-subquery-as-table-name-to-another-query-in-yii2) — mrateb, Feb 12 '18 at 08:22
Possible duplicate of [Yii2 subquery in Active Record](https://stackoverflow.com/questions/30164491/yii2-subquery-in-active-record) — Muhammad Omer Aslam, Feb 12 '18 at 08:54

score 0 · Accepted Answer · answered Feb 12 '18 at 07:38

0

Since you want to use first query as pure string add

->createCommand()->rawSql;

to it. This generates SQL statement out of Query object.

answered Feb 12 '18 at 07:38

Bizley

17,392
5
49
59

how to use subquery inside select statement of yii2

1 Answers1