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(
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.