romanoza
(Romanoza)
1
I have these conditions for request:
$criteria->addCondition('bsoNameId='.$_POST['name']);
$criteria->addCondition('regId='.$_POST['region']);
$criteria->addCondition('insId='.$_POST['company']);
if(isset($_POST['essentialField'])) {
foreach($_POST['essentialField'] as $n=>$field) {
if(trim($field)!='') {
$criteria->addCondition('bsoFieldId = '.$n);
$criteria->addCondition('text like \'%'.$field.'%\'');
}
}
}
this request:
Bso::model()->with('bsoType.bsoName','bsoContents')->count($criteria)
looks like
but this:
Bso::model()->with('bsoType.bsoName','bsoContents')->findAll($criteria)
like:
this query does not contain BsoContent table join, why?
PS Bso model relations:
return array(
'bsoType' => array(self::BELONGS_TO, 'BsoType', 'bsoTypeId'),
'bsoContents' => array(self::HAS_MANY, 'BsoContent', 'bsoId'),
);
tri
(tri - Tommy Riboe)
2
Did you try together() ?
http://www.yiiframework.com/doc/api/CActiveFinder#together-detail
/Tommy