Clist Join Tables

Yii 1.1 General Discussion
1

Hi, in my app having 2 model- program, and program detail.

Program


program_id, program_name

 1                     prog 1

 2                     prog 2                       

 3                     prog 3

Program_detail


detail_id, program_id, status

        1         2                 1

        2         1                 1

        3         3                 0

Form this i want to show programs having status 1 in clist view. In data provider how criteria will set?




$criteria=new CDbCriteria(array());


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

$this->widget('zii.widgets.CListView', array(

	'dataProvider'=>$dataProvider,

	'itemView'=>'myprogram',

)); ?>

Thanks

2

$criteria->addCondition(‘status=1’);

or search google for ‘Yii CDbCriteria condition’.

3

Here status is not a field of Program model. Then how it can use in criteria?

4 

$criteria->with('DetailRelation');

$criteria->addCondition('DetailRelation.status=1');