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;
} |