Sometimes you might face an error “Invalid Attribute” in admin panel grid during filtering or sorting after you have joined product (for example) with your table.<\/p>\n
Suppose your join is something like this-<\/p>\n
protected function _prepareCollection()\r\n{\r\n $collection = Mage::getModel('catalog\/product')->getCollection();\r\n $prefix = Mage::getConfig()->getTablePrefix();\r\n $collection->getSelect()->joinLeft(\r\n array('map' => $prefix.\"webkul_product_demo_mapping\"),\r\n 'map.magento_id = e.entity_id',\r\n array('magento_id','status','created_at')\r\n );\r\n $this->setCollection($collection);\r\n return parent::_prepareCollection();\r\n}\r\n<\/pre>\nYou are displaying your grid column like this<\/p>\n
$this->addColumn('magento_id', array(\r\n 'header' => Mage::helper('webkul')->__('Magento Id'),\r\n 'align' => 'center',\r\n 'index' => 'magento_id',\r\n));\r\n\r\n<\/pre>\nNow if you are getting “Invalid Attribute” error during searching or sorting your column magento id, it is because magento thinks magento_id <\/em>you are calling an attribute of product but as magento_id\u00a0<\/em>is not an attribute of product so it displays an error.<\/p>\nSo what you need to do is use the following code –<\/p>\n
<\/p>\n
$this->addColumn('magento_id', array(\r\n 'header' => Mage::helper('webkul')->__('Magento Id'),\r\n 'align' => 'center',\r\n 'index' => 'magento_id',\r\n 'filter_condition_callback' => array($this, 'filterMagentoId'),\r\n 'order_callback' => array($this, 'orderMagentoId')\r\n));\r\n\r\n<\/pre>\nHere two functions are called.<\/p>\n
For filter<\/h4>\nprotected function filterMagentoId($collection, $column)\r\n{\r\n if ($column->getFilter()->getValue() === null) {\r\n return;\r\n }\r\n $collection->getSelect()->where('map.magento_id like ?', '%' . $column->getFilter()->getValue() . '%');\r\n}\r\n<\/pre>\nFor sorting<\/h4>\nprotected function orderMagentoId($collection, $column)\r\n{\r\n $collection->getSelect()->order($column->getIndex() . ' ' . strtoupper($column->getDir()));\r\n}\r\n<\/pre>\nThat’s it.<\/p>\n
Happy coding \ud83d\ude42<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"