Usage of scopes in relations()

bitmatix · May 12, 2009, 1:15pm

Can I use scopes in relations function like this???

public function relations()

{

return array(


&nbsp; &#039;arrTeaserImage&#039;&nbsp; &nbsp; =&gt; array(self::HAS_MANY, &#039;TeaserDocument&#039;, &#039;idTeaser&#039;,


&nbsp; &nbsp; &#039;with&#039; =&gt; &#039;objDisplayType:teaser&#039;


&nbsp;&nbsp; )


);

}

In TeaserDocument I defined a scope named "teaser", but nothing happens…

qiang · May 12, 2009, 1:55pm

teaser should be defined in the objDisplayType class…

bitmatix · May 12, 2009, 2:13pm

Quote

teaser should be defined in the objDisplayType class...

Sorry, my fault. Of course it is defined in objDisplayType class, but still nothing happens. It seems like the "with" is ignored…

qiang · May 12, 2009, 2:16pm

What is the generated SQL? Note that 'with' option is only used by lazy loading.

bitmatix · May 12, 2009, 2:45pm

Quote

What is the generated SQL? Note that 'with' option is only used by lazy loading.

Ah ok, how can I handle it for the following?

Vehicle::model()->with('arrTeaserImage')->findAll();

Has it got to be like that:

Vehicle::model()->with('arrTeaserImage.objDisplayType:teaser')->findAll();

?

EDIT:

Yes, that works, but how can I define that in function "relations", for eager loading?

qiang · May 12, 2009, 4:21pm

I just checked in a fix to make 'with' working with eager loading. Thanks.