Filter Not Working in Grid – Troubleshooting Guide

backendgridgrid-serlization

I have a custom module with a backend grid and an edit form.
In the edit form I have some tab one contains a grid for associated products.

I have implemented the grid int the tab using the code from the products grid for related products.

Now everything seems to work and checkbox are selected according to data from collection.

The only issue is related to the filter Yes/No/Any that doesn't work:
setting the filter to "yes" I have an empty grid, instead if I set the filter to "No/Any" I can see all the products and also the product selected.

So it looks like some association to between the filter and the field name are missed

Best Answer

On the webguys page is a german article about this problem: http://www.webguys.de/magento/turchen-23-pimp-my-produktgrid/

Nicht alle unsere Änderungen werden von Magento übernommen, zum Beispiel funktioniert die Sortierung und Filterung der neuen Attribute nicht.

Das liegt daran, dass unsere Änderungen nach dem Aufruf von _prepareCollection(), in dem die Spalteninfos an die Collection übergeben werden, stattfinden.

Translation:

Not all changes are made by magento, e.g. sorting and filtering of the new attributes doesn't work.

That's because they are made after the _prepareCollection() call, where the informations about the columns are passed to the collection.

protected function _callProtectedMethod($object, $methodName) {
    $reflection = new ReflectionClass($object);
    $method = $reflection->getMethod($methodName);
    $method->setAccessible(true);
    return $method->invoke($object);
}

protected function _modifyProductGrid(Mage_Adminhtml_Block_Catalog_Product_Grid $grid) {
 
    $this->_addUpdatedAtColumn($grid);
    $this->_addColorColumn($grid);
 
    $this->_removeColumn($grid, 'set_name');
    $this->_removeColumn($grid, 'visibility');       

    // reinitialisiert die Spaltensortierung
    $grid->sortColumnsByOrder();
    // reinitialisiert die Sortierung und Filter der Collection
    $this->_callProtectedMethod($grid, '_prepareCollection');               

}

More in the post. I think the source code is quite self explaining and if not, use google (if you don't understand german ;-))

Related Solutions

Magento – Ajax Not Working in Grid Edit Form (Backend)

There are quite some tutorials explaining how to add a custom admin grids. Unfortunately some of them are missing the fact that sorting and filtering functionality require additional controller action.

This action is specified by getGridUrl() method of your grid class. The pitfall is that this method is defined in Mage_Adminhtml_Block_Widget_Grid so if you forget to override it you may notice it until you try to sort or filter your grid. Mage_Adminhtml_Block_Widget_Grid::getGridUrl() returns $this->getCurrentUrl() which doesn't make much sense. So obvious move would be to override it with something like this:

public function getGridUrl()
{
    return $this->getUrl('*/*/grid', array('_current'=>true));
}

The simple controller action that will just render a layout will wrap things up:

public function gridAction()
{
    $this->loadLayout();
    $this->renderLayout();
}

Magento – To fetch product id from product grid under custom module tab

The normal behaviour for the grid checkbox is to bind a js event to it, and action the checkbox check/uncheck. Normally this would be to populate a hidden field with the selected values, and then that field is what gets posted to your controller action.

See varienGrid.prototype /js/mage/adminhtml/grid.js : (this.checkboxCheckCallback) and also setCheckboxChecked method in that class.

For this reason the checkbox element generally do not get a name assigned to it, which you can see if you view your element properties.

enter image description here

This is thus the reason why you cannot get the selected options in your post action, since elements with no name will not post in the form, and you most likely do not have the required callback set to deal with the check/uncheck of the box. Using the callback js, you could also effect other actions in your gui, to enhance the user experience.

However, looking at your usage requirements, you may just get away with setting a name for the checkbox element, which will then post the data to your action.

Thus if you adjust your element definition to this (adding in the 'field_name' property), you will get your data in an array called 'selectedproducts'

$this->addColumn('in_category', array(
                'header_css_class' => 'a-center',
                'type'      => 'checkbox',
                'values'    => $this->_getSelectedProducts(),
                'align'     => 'center',
                'index'     => 'entity_id',
        'name'      => 'in_category',
                'field_name' => 'selectedproducts[]'
            ));

Hope that helps.

Best Answer

Related Solutions

Magento – Ajax Not Working in Grid Edit Form (Backend)

Magento – To fetch product id from product grid under custom module tab

Related Topic