Hi guys,
How to fitler the result in CgridView when i using $dataProvider instead of $model->search(). Anyone got try it before?
$dataProvider = new CSqlDataProvider($sql, array(
'totalItemCount' => $count,
'pagination' => array(
'pageSize' => 10,
),
));
$this->widget('zii.widgets.grid.CGridView', array(
'id' => 'detail-grid',
'dataProvider' => $dataProvider,
//'filter' => $model, ----> filter based on $dataProvider
'columns' => array(
array(
'name' => 'created',
'header' => 'Time'
),
array(
'name' => 'machine_tag',
'header' => 'Machine Name'
),
array(
'name' => 'description',
'header' => 'Product'
),
Thx.