CGridView filter with relations

[le_top (Ext Yiiframework Com)]

Hi

Check out my RelatedSearchBehaviour Extension. It will make this stuff easier to do.

[ione (Kardiwan)]

I’m also trying to find a way around this.

In my case I have Addresses and Businesses

In my Address admin search I want to also have searchable the business information that is linked to the address.

Each Address is linked with a business_id foreign key to a business.

I can use the solution from eval’s posted link to display a text box for the filter on say the business name:

array(

      'name'=>'business_id',

      'value'=>'Businesses::model()->FindByPk($data->business_id)->name',

    ),

However I can’t figure out a way to have the other business information searchable, eg:

    array( 

      'name'=>'business.url', 

      'value'=>'Businesses::model()->FindByPk($data->business_id)->url',

    ),

If I use code like the above, I can get the url to display in the grid but even after looking through the forums I can’t find a method that will let me enable a filter for it as well.

My Code:

array('name'=>'region_id', 'header'=>'Region', 'value'=>'Region::model()->FindByPk($data->region_id)->region_name'),

Thank you Orteko,

[cappadochian]

I was following this wiki article, and for me it was absolutely not working. And finally I could solve this based on Hollyii’s Yii Blog article.

BR

c

[sigitpurnomo7680]

Hi all,

How about this wiki ?

http://www.yiiframework.com/wiki/281/searching-and-sorting-by-related-model-in-cgridview/

It works.