How to get the contents of another table in Yii?

Question

I’d like to replace the ID, display the employee’s name.

<?php
$this->widget('zii.widgets.grid.CGridView', array(
    'id'=>'documento-grid',
    'dataProvider'=>$model->search(),
    'columns'=>array(
        'id_documento',
        'nome_documento',
            array(
            'name'=>'Download',
            'header'=>'Download',
            'type'=>'raw',
            'value'=>'CHtml::link($data->path_documento, array("documento/download","id"=>$data->id_documento))',
            //'htmlOptions'=>array('width'=>'10%'),
        ),
        'id_documento_funcionario',
        array(
            'class'=>'CButtonColumn',
            'template'=>'{view}{delete}',
        ),
    ),
)); 
?>

Answer 1

Hello,

You can do it this way:

http://www.yiiframework.com/wiki/721/view-a-related-field-in-cgridview/

'columns' => array(
    'funcionario.nome',
    // outras colunas...
),