cdbcriteria check if relation is empty

Yii 1.1 General Discussion
1

I would like to show only books that dont have feedback.


$criteria = new CDbCriteria;

        $criteria->with = array('feedbacks');

        

        $criteria->compare('feedbacks.reserva', null);

or


$criteria->compare('feedbacks', null);

Thanks

2

try something like




$criteria->compare('feedbacks.id', null);

where "id" should be PK column from feedbacks table

or (I think better) do not join with feedbacks but instead:




$criteria->addCondition( 'NOT EXISTS (SELECT id FROM feedback WHERE feedback.id_book = t.id)' );
3

Thanks redguy, second aproach works .

4

Best way is to set up relation condition

$criteria->addCondition(‘feedbacks.id IS NULL’);

5

nice :)