CODEWITHSUNDEEP
mysqlyii
nicky
nicky

Reputation: 817

Subquery in criteria - translate mysql into yii CActiveDataProvider with same table

How would this translate into the yii CActiveDataProvider structure?!

SELECT t1.*
FROM data t1
WHERE t1.date= (SELECT MAX(t2.date)
 FROM data t2
 WHERE t2.fromNumber = t1.fromNumber)

Thanks

Upvotes: 4

Views: 350

Answers (1)

Kumar V
Kumar V

Reputation: 8830

Try this code: Untested. Please check.

Hope you have created model for this table. Replace your model name in the place of Model_name

$dataProvider=new CActiveDataProvider('Model_name', array(
            'criteria'=>array(
             'condition'=>'t.date = (SELECT MAX(t2.date)
                                     FROM data t2
                                     WHERE t2.fromNumber = t1.fromNumber)'
                       )
    )
    );

This worked: 

        $dataProvider=new CActiveDataProvider('Data', array(
            'criteria'=>array(
                'condition'=>'t.date = (SELECT MAX(t2.date)
                FROM data t2
                WHERE t2.fromNumber = t.fromNumber)'),
            ));

Upvotes: 3

Related Questions