[SOLVED] Filter CGrid Ga Jalan a.k.a ERROR -> bantuin gan

Gini gan, waktu ane mau entry nilai di filter kolom NIM bisa gan, trus di filter id_jadwal jg bisa gan, nah cuma pas entry nilai di filter kolom thn_ajaran hasilnya malah error gan, Errornya kaya gini gan : 1585

error.JPG

nih di view-nya gan




<?php $this->widget('zii.widgets.grid.CGridView', array(

	'id'=>'nilai1-grid',

	'dataProvider'=>$model->search(),

	'filter'=>$model,

	'columns'=>array(

                 array(

                'header'=>'NIM',

                'name'=>'id_krs',

                'value'=>'$data->idKrs0->nim',

                ),

                'idKrs0.nim0.nama_mahasiswa',

                 array(

                'name'=>'thn_ajaran',

                'value'=>'$data->thn_ajaran',

                'filter'=>CHtml::listData(Nilai1::model()->findAll(),'thn_ajaran','thn_ajaran'),

                ),

                'idKrs0.idKurikulum0.idMataKuliah0.nama_mata_kuliah',

                //'idKrs0.idJadwal0.id_kelas',

                 array(

                'name'=>'id_jadwal',

                'value'=>'Jadwal::model()->FindByPk($data->id_jadwal)->id_kelas',

                'filter'=>CHtml::listData(Jadwal::model()->findAll(),'id','id_kelas'),

                .......



Nih modelnya gan




public function search()

	{

		// Warning: Please modify the following code to remove attributes that

		// should not be searched.


		$criteria=new CDbCriteria;


		$criteria->compare('id',$this->id);

		//$criteria->compare('id_krs',$this->id_krs);

		$criteria->compare('id_jadwal',$this->id_jadwal,true);

		$criteria->compare('thn_ajaran',$this->thn_ajaran);

                

                $criteria->with=array('idKrs0');

                $criteria->addSearchCondition('idKrs0.nim',$this->id_krs);

                ................



Oiya gan, tapi kalau




public function search()

	{

		// Warning: Please modify the following code to remove attributes that

		// should not be searched.


		$criteria=new CDbCriteria;


		$criteria->compare('id',$this->id);

		$criteria->compare('id_krs',$this->id_krs);

		$criteria->compare('id_jadwal',$this->id_jadwal,true);

		$criteria->compare('thn_ajaran',$this->thn_ajaran);

                

                // Ga dipakai...

                //$criteria->with=array('idKrs0');

                //$criteria->addSearchCondition('idKrs0.nim',$this->id_krs);

                ................



Hasilnya-> masukin nilai di kolom filter thn_ajaran bisa gan, ga error kaya yg di atas,

cuma jadinya filter di kolom NIM-nya ga berfungsi,

Agan2 sekalian mohon pencerahannya,

bilangnya ambigu tuh, coba tambah tabel alias

jd t.thn_ajaran yg ada di method seacrh()




$criteria->with=array('idKrs0');

$criteria->addSearchCondition('idKrs0.nim',$this->id_krs);




itu bener tuh idKrs0.nim disimpen sama variabel id_krs???

trus itu relations nya udah bener belom,

coba dicek dulu gan…

Makasi agan2 skalian,

udah Solved -> ditambahin t.thn_ajaran

senang anda berhasil…