How to filter drop-down in custom grid in my case its throwing error Below is my grid code
protected function _prepareColumns()
{
$this->addColumn('attribute', array(
'header' => Mage::helper('moduelname')->__('Test'),
'align' =>'left',
'index' => 'attribute',
'type' => 'options',
'renderer' => 'ModuleName_Namespace_Block_Adminhtml_Renderer_Test',
'options' => array(
'0' => Mage::helper('moduelname')->__('Please Select'),
'1' => Mage::helper('moduelname')->__('On Hold'),
'2' => Mage::helper('moduelname')->__('Credit Hold'),
'3' => Mage::helper('moduelname')->__('Open'),
),
));
return parent::_prepareColumns();
}
protected function _prepareCollection()
{
$collection = Mage::getModel('sales/order_status')->getResourceCollection();
$this->setCollection($collection);
return parent::_prepareCollection();
}
ERROR:
a:5:{i:0;s:203:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'attribute' in 'where clause', query was: SELECT COUNT(*) FROM
sales_order_status
ASmain_table
WHERE (attribute = '1')";i:1;s:5177:"#0 /var/www/test /lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)