Advanced Search Not Working using CSqlDataProvider

archean · June 25, 2015, 7:08pm

Hello All, I am a beginner with Yii, While I was using a CSqlDataProvider in my view, I was not able to make use of my ‘filter’ in the CGridView

$this->widget(‘zii.widgets.grid.CGridView’, array(

    'id'=&gt;'Id',


     'dataProvider' =&gt;new CSqlDataProvider(&#036;sql),


    //  'filter'=&gt;&#036;model,//Shows an error when I do this

Please, post your thoughts on this one.

Thank You.

reykel · November 29, 2015, 11:41pm

We should take a look at the big picture, especially the SQL statement. But I suggest you CACtiveDataProvider with a advanced use of it possibilities. The use of SQL in a direct way must be avoid for getting a high quality code… Keep it so simple doesn’t mean a simple coding job… at all… keep communication bro…