5

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 AS main_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)

  • shoe more details – Amit Bera Feb 27 '15 at 10:32
  • isnt it just replacing "attribute" with your actual attribute name? – Stefan Gregori Feb 27 '15 at 11:01
  • Please show more details. Specifically the _prepareCollection function. – Conrad Jones Feb 27 '15 at 11:39
  • I edited Question please take a look – Magento AJ Feb 27 '15 at 12:40
  • Its giving error because there is no any field or attribute in your collection please check you collection first. – Hardik Shah Feb 27 '15 at 12:46
0
options' => array('Please Select', 'On Hold' => 'On Hold', 'Credit Hold' => 'Credit Hold', 'Open' => 'Open')

Why don't you just put each label as string? This worked fine for me.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.