sorting relation table in yii's view -

sorting relation table in yii's view -

i trying sorting in clistview.. works fine me sorting attributes same table.. want know if possible sort based on fields related table.. example..

<?php $this->widget('zii.widgets.clistview', array( 'dataprovider'=>$dataprovider, 'itemview'=>'_viewnew', 'sortableattributes'=>array( 'code' ), )); ?>

works fine.. wish sort table field this..

<?php $this->widget('zii.widgets.clistview', array( 'dataprovider'=>$dataprovider, 'itemview'=>'_viewnew', 'sortableattributes'=>array( 'relation_name.make' ), )); ?>

this have far!! , doesn't work

in model

/** * @return array relational rules. */ public function relations() { // note: may need adjust relation name , related // class name relations automatically generated below. homecoming array( 'pmake'=>array(self::belongs_to, 'pmake', 'id'), ); }

in controller

public function actionindex() { $dataprovider=new cactivedataprovider('table1'); $criteria=new cdbcriteria; $criteria->together=true; $criteria->with=array('pmake'); $dataprovider->criteria=$criteria; $dataprovider->sort->defaultorder='pmake.make asc'; $this->render('index',array( 'dataprovider'=>$dataprovider, )); }

in view, the sort here i'm trying work.

<?php $this->widget('zii.widgets.clistview', array( 'dataprovider'=>$dataprovider, 'itemview'=>'_view', 'sortableattributes' => array('pmake.make'=>'make'), 'loadingcssclass' => '', //remove loading icon )); ?>

try in controller

public function actionindex() { $dataprovider=new cactivedataprovider('table1'); $criteria=new cdbcriteria; $criteria->together=true; $criteria->with=array('pmake'); //made changes here $criteria->order = 'pmake.make asc' $dataprovider->criteria=$criteria; $this->render('index',array( 'dataprovider'=>$dataprovider, )); }

yii