[Not a bug, solved] Eager load in relational AR bug

Archives Bug Discussions
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'),

		);
2

Did you try together() ?

http://www.yiiframework.com/doc/api/CActiveFinder#together-detail

/Tommy

3

Yes, thanx :)

my fault