Searching and sorting by related model in CGridView

Comparing #1 with #2

Revision #2 was created by Maciej Liżewski Maciej Liżewski on Dec 1, 2011, 6:51:53 PM.

How to allow searching and sorting with respect to related active record column in CGridView

Content

[...]
```php
$criteria = new CDbCriteria;
$criteria->with = array( 'author' );
...
$criteria->compare( 'author.username', $this->author_search, true );
...
```
[...]
'attributes'=>array(
'author_search'=>array(
'asc'=>'author.username', 'desc'=>'author.username DESC',
),
'*',
[...]
'title',
'post_time',
array( 'name'=>'author_search', 'value'=>'$data->author->username' ),
array(
'class'=>'CButtonColumn',
),
),
));
[...]