如何在CActiveDataProivder中添加模型别名yii

Question

I have User model with "type" attribute. and Product model with "title". Here is my code.

$criteria = new  CDbCriteria;
$criteria->addCondition('type = "ABC"');    
$criteria->mergeWith ( array (
            'with' => 'products'
        ) );

$criteria->mergeWith ( array (
            'condition' => "`products`.title LIKE '". $model->title ."'",
            'together' => true
        ) );

$dataProvider = new CActiveDataProvider('User', array(
        'criteria' => $criteria,
    ));

It is giving following error:-

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: 
Integrity constraint violation: 1052 Column 'type' in where clause is ambiguous

My question is, how to add alias for User model so the User.type = "ABC" using above approch.

Answer 1

$criteria = new  CDbCriteria;
$criteria->compare('t.type' => "ABC");    
$criteria->with= array('products'=>array('on'=>"title LIKE '$model->title'"));

$criteria->together=true;

$dataProvider = new CActiveDataProvider('User', array(
        'criteria' => $criteria,
    ));

if does not work please paste full error with whole query