Sorting by relationship value

Yii 1.1 General Discussion
1

Hello, I have a list of items in the admin (manage) page for my Stories model. Each Story has an Engine associated with it. The first column in this admin view is “Engine Name”, which is part of the Engine table. This relationship is defined in the Story and Engine model files. However, on this page I can’t search by Engine Name. The input box for filtering items is gone for the Engine Name, but still there for the other columns. Also, I’m not sure how to allow for searching by Engine Name in the advanced view either. Any help is appreciated, thanks!

2

Add it to search. :)

Like this:


	public function search() {

    	// Warning: Please modify the following code to remove attributes that

    	// should not be searched.


    	$criteria = new CDbCriteria;


    	$criteria->with = array('engine'); // use name of your relation here

    	$criteria->compare('id', $this->id);

    	$criteria->compare('engine.name', $this->engine_id);

     	....morecode...
3

And then, in the view:


            	array(

                	'name' => 'engine_id',

                	'header' => 'Engine Name',

                	'value' => '(($data->version)?$data->engine->name:"")',

                	'filter' => $this->getEngineFilter(),

                	'htmlOptions'=>array('width'=>'10'),

            	),

'getEngineFilter retuns an array of all engine names.

4

ugh nothing’s working, I’ll have to give it a try later. Thanks.

5

Make sure that you’re using an array like:


foreach($engines as $engine) {

$array[$engine->name] = $engine->name;

}

return $array;

Then you should get a nice filter dropdown in the grid.

6

Thanks it’s working great!