Overview

Common tasks and adjustments when working with Yii's CGridView and CDbCriteria.

Limit Result Set Based on a Condition

The following addition to MyModel.php will present a searchable gridview which includes only items where
Model.active = 1.

public function search() {

  $criteria=new CDbCriteria;

  $criteria->condition = 'active = 1';  
  $criteria->compare('id',$this->id);
  $criteria->compare('url',$this->url,true);
  $criteria->compare('active',$this->active);

  return new CActiveDataProvider($this, array(
    'pagination' => array(
      'pageSize' => 50,
    ),  
    'criteria'=>$criteria,
  ));
}