使用defaultScope属性从模型创建条件时出错来自连接模型

Question

I have add parameter from joined attribute (event.deleted_at, event.status) in defaultScope method Model:

public function defaultScope()
{
    return array(
            'condition'=>'
                lp_deleted_at is NULL 
                AND event.e_deleted_at IS NULL
                AND event.status = TRUE
        '
    );
}

Error in last line (addSearchCondition)when creating criteria:

 $criteria=new CDbCriteria;



     $criteria->with = array( 
                                     'lokasi_pengamatan'=>array('select'=>'lokasi_pengamatan.nama','together'=>true),
                                     'event'=>array('select'=>'event.id_event','together'=>true)

   $criteria->addSearchCondition('lokasi_pengamatan.nama', '%'.$this->lokasi_pengamatan.'%', false, 'AND', 'ILIKE');

Error Message

Undefined table: 7 ERROR: missing FROM-clause entry for table "event"

Answer 1

I usually write the SQL using CDbCriteria a bit different:

private function searchByUser(){
    $criteria         = new CDbCriteria;
    $criteria->select = 'QuestionForm.*';
    $criteria->addCondition('QuestionForm.user_id = $this->user_id');
    return $this->with(array('QuestionForm'))->findAll($criteria);
}