Combining relational query and CDbCriteria


I don’t understand how to combine relational query with a CDbCriteria in order to get all the related records (‘items’ in the following example) of an instance with some specific conditions.

I wrote something like this but it doesn’t work. Do I need to use ‘scopes’ to achieve this ?

$criteria = new CDbCriteria(array(

                    'condition' => 'start_date > '.$now,

                    'order' => 'start_date ASC',


$items = $this->items(array(



Thank you,



You’re almost there:

$items = $this->items(array('condition' => 'start_date > :now', 'order' => 'start_date ASC', 'params' => array(':now' => $now)));

It just doesn’t take CDbCriteria as a parameter, it takes the same parameters as is specified in a relation.