Filters Using Relationship Id

Yii 1.1 General Discussion
1

I have problem with filters using relationship id like:

in Model

return array(

‘mname’ => array(self::BELONGS_TO, ‘Voilencemethods’, ‘name’),

);

using in GridView

array(

		'name'=>'name',


		'value'=>'$data->mname->name',


		'filter'=>CHtml::listData(Voilencemethods::model()->findAll(), 'id', 'name'),

),

But when i select a value from dropdown list having id like 1 it also load all the name having id 10, 11, 12 …, in short all those IDs having 1.

Kindly any solution?

2

Hi,

you must search using name, not id, so your filter shoud be




'filter'=>CHtml::listData(Voilencemethods::model()->findAll(), 'name', 'name'),
3

why you on earth you wanna do that just change your search method under you model




public function search()

{

    ...

    $criteria->compare('id',$this->id,true); // change true to false (third arg)

    ...

}