A related hyperlink column in CGridView, CDetailView, CListView

Say you have an order table and it has a status id. You want to display the status name and not the id, as a hyperlink, that links to the status view page, where you can see other info about that status. Here's how to do it:

relation name: status_relation
id field: status_id
name field: name
related controller name: status_controller
label: Status

In your 'columns' array in a CGridView declaration:

array('name'=>'status_id', 'type'=>'raw', 'value'=>'CHtml::link($data->status_relation->name, array("status_controller/view", "id"=>$data->status_id))', 'header'=>'Status'),

watch your single and double quotes

$data is the name of the model record when inside a CGridView

This method allows for searching and sorting, as long as you adjust your model's search function as per the previous post.

In your 'attributes' array in your CDetailView:

array('label'=>'Status', 'type'=>'raw', 'value'=>CHtml::link($model->status_relation->name, array('status_controller/view','id'=>$model->status_id))),

In the _view of your CListView:

CHtml::link(CHtml::encode($data->status->name), array('status_contoller/view', 'id'=>$data->status_id));