Mapping three table relationships in yii gridview

Question

I get foreign key mapping identifiers in gridviews. How to get values ​​instead of identifiers? The code in my gridview is as follows:

$criteria->compare('education.UniversityNameid',$this->UniversityName, true); 

my gridviews inside code

 array( 
             'name' => 'UniversityName',
             'type' => 'raw',
                'value'=>'(empty($data->education->UniversityNameid))? "" : Yii::app()->params["currencySymbol"]." ".$data->education->UniversityNameid',

       ),

Answer 1

You have to establish a relationship in your "University" model like this

public function relations() {
        // NOTE: you may need to adjust the relation name and the related
        // class name for the relations automatically generated below.
        return array(
            'UniversityName' => array(self::BELONGS_TO, 'University', 'UniversityNameid'),
        );
    }

Thank you for accessing the name

$data->education->UniversityName

Answer 2

Establish a relationship in your model, for example

'u' => array(self::BELONGS_TO, 'University', 'UniversityNameid'),

and deal with her like

  'attributes'=>array(

            array('name'=>'u.UniversityName',
            'label'=>'University',),


   ),