Three Table Join In Cdetailview

air_cooled · September 11, 2012, 1:41pm

I’ve got an app with:

Contact

Address

Region

Where a Contact has an Address, and an Address has a Region.

When showing the Contact in CDetailView, I’d like to be able to show the Region name rather than the region_id which is a property of the Address.

I’ve already got this:

$this->widget(‘zii.widgets.CDetailView’, array(

'data'=&gt;&#036;model,


'attributes'=&gt;array(


	'id',


	'name',


	'address.address1',


	'address.address2',


	'address.city',


	'address.region_id',


	


),

Which works fine, the address.whatever entries show the related data for the address object, but now I need to go that one step further, and I don’t know if I can nest a second request here somehow, or build it into the controller and use it here… I’m fairly new to yii, although I’m enjoying it so far.

Hopefully someone can help.

Thanks