Yii Booster Gridview table joining table

Yii 1.1 General Discussion
1

i want to create a table like this Yii Booster Gridview table

here is my code in controller:

$rawData=Jobspecs::model()->with(‘customer’)->findAll();

$gridDataProvider=new CArrayDataProvider($rawData, array(

'id'=>'user',





'sort'=>array(


    'attributes'=>array(


         'id', 'customer',


        ),





    ),





));

$gridColumns = array(

array('name'=>'id', 'header'=>'Js No.', 'htmlOptions'=>array('style'=>'width: 60px')),





array('name'=>'WHAT TO PUT HERE TO SHOW CUSTOMER NAME', 'header'=>'Customer Name'),





array(





    'htmlOptions' => array('nowrap'=>'nowrap'),





    'class'=>'booster.widgets.TbButtonColumn',





    'viewButtonUrl'=>null,





)





);

in my model sapcustomers:

return array(

        'customer'=>array(self::BELONGS_TO, 'Sapcustomers', 'customer'),


    );

jobspecs model

return array(

        'cardname'=>array( self::HAS_MANY, 'Jobspecs', 'customer' ),


    );

my view

<?php

    &#036;this-&gt;widget(


        'booster.widgets.TbGridView',


        array(


            'type' =&gt; 'bordered',


            'dataProvider' =&gt; &#036;gridDataProvider,


            'template' =&gt; &quot;{items}&quot;,


            'columns' =&gt; &#036;gridColumns,


        )


    );

?>

as you can see i joined sapcustomers and jobspecs table. my question is what code i need to put on the $gridcolums to show the customer name data from the table sapcustomer. thanks for the help

2

Try with:




array('name'=>'customer.name', 'header'=>'Customer Name'),

If your attribute of customer table is ‘name’.