Add a sql like to filter column in grid
<?php protected function _addColumnFilterToCollection($column) { if ($column->getId() == 'name') { $this->getCollection()->addFieldToFilter($column->getId(), array('like' => $column->getFilter()->getValue() . '%')); ... $this->getCollection()->addFieldToFilter($column->geId(), $column->getFilter()->getCondition()); ... $this->getCollection()->addFieldToFilter('name', array('like' => '%' . $name . '%')); else { parent::_addColumnFilterToCollection($column); } return $this; } |