Filter Column Extracted From Another Table

I have a view that has following BootGridView,


$this->widget('bootstrap.widgets.BootGridView', array(

    'id' => 'project-grid',

    'dataProvider' => $model->search(),

    'filter'=>$model,

    'columns' => array(

        array('header' => 'Name',

            'value' => '$data->client->firstname." ".$data->client->lastname'),

        array('header' => 'picture',

            'type' => 'raw',

            'value' => '$data->getProjectPicture($data->id)'),

        array('header'=>'Status','name' => 'is_approved',

            'type' => 'raw',

            'value' => '$data->is_approved == 1 ? "Approved" : CHtml::ajaxLink("Not Approved", array("approve", "id" => $data->id), array("success" => "approve($data->id)"), array("id" => "approve_" . $data->id))'

        ),

        array('name' => 'date',

            'value' => 'date("Y/m/d", strtotime($data->date))'),

        array('header' => 'Managed By',

            'value' => '$data->getAdvisor($data->id)'),    

        /*




          'project_status',

         */

        array(

            'class' => 'BootButtonColumn',

            'template' => '{view}{delete}',

        ),

    ),

));

The filter works well for all the column extracted from same table, Name field is extracted from anotehr table, HOW DO I ENABLE FILTER ON NAME COLUMN? Thanks in advance,.

Hi Suesh,

Please check this wiki:

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