cristeria condition relation

Yii 1.1 General Discussion
1

Hi.

Can you help me with this problem? I have readed many post and I can’t resolve it…


class Tickets extends CActiveRecord{

	

	[...]

	

	public function relations(){

		

		return array(

			'assigned'=>array(self::HAS_ONE, 'Assignments', array( 'userid'=>'ticketid' ),

                        'on'=>"assigned.table='ASN' AND

							assigned.status = 'ACTIVE' "),

		);

	}

		

	public function searchCriteria(){

	

		[...]

		

		$criteria->addCondition("assigned IS NOT NULL");

		

		[...]

	

	}

	

	[...]

	

}

Output:


Column not found: 1054 Champ 'assigned' inconnu dans where clause
2

Assuming you’ve already included that relation in your search method:




$criteria->addCondition("assigned.status IS NOT NULL");