Magento insert and filter multi-select values in custom admin-grid module

Magento insert and filter multi-select values in custom admin-grid module

September 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento insert and filter multi-select values in custom admin-grid module

Handling Multi-Select Values in Magento Custom Admin-Grid Modules

When working with custom admin modules in Magento, handling multi-select field values can be a bit challenging, especially when it comes to saving and filtering those values properly in your grid. Let’s dive into how you can achieve this efficiently.

Storing Multi-Select Values Correctly

You’re already on the right track by manipulating the submitted array value before saving it to the database. Here’s an example of a more clean approach using the saveAction() method:

public function saveAction()
{
    $data = $this->getRequest()->getPost();
    if ($data) {
        $model = Mage::getModel('module/model');
        $model->setData($data);
        try {
            $model->save();
            Mage::getSingleton('adminhtml/session')->addSuccess(Mage::helper('module')->__('Item was successfully saved'));
            $this->_redirect('*/*/');
        } catch (Exception $e) {
            Mage::getSingleton('adminhtml/session')->addError($e->getMessage());
            $this->_redirect('*/*/edit', array('id' => $this->getRequest()->getParam('id')));
        }
    }
}

In this case, the $data variable contains all the post data from your form, including the multi-select field. You can use a library like json_encode() or implode() to convert the array into a string before saving it.

Filtering Multi-Select Values in Your Grid

To filter multi-select values in your grid, you’ll need to create a filter input type and handle it accordingly. Here’s how you can do this:

  1. Create a new system config file for your custom filter:

    In app/code/local/YourCompany/YourModule/etc/system.xml, define the new filter within the <config> section:

    <filter_input_type>
        <label>Multi-Select Filter</label>
        <backend_model>yourcompany_yourmodule/model_filter_backend_multi</backend_model>
        <input_type>select</input_type>
        <sort_order>1000</sort_order>
    </filter_input_type>
    
  2. Create the filter backend model:

    In app/code/local/YourCompany/YourModule/Model/Filter/Backend/Multi.php, create a new model to handle the filtering:

    class YourCompany_Yourmodule_Model_Filter_Backend_Multi extends Mage_Eav_Model_Entity_Attribute_Backend_Abstract
    {
        public function applyFilterToCollection($collection, $column)
        {
            if ($value = $column->getFilter()->getValue()) {
                $collection->addFieldToFilter('your_attribute', array('like' => '%' . $value . '%'));
            }
            return $this;
        }
    }
    
  3. Update your grid collection:

    In your grid model’s _prepareCollection() method, add the filter condition:

    public function _prepareCollection()
    {
        parent::_prepareCollection();
        $collection = $this->getCollection();
    
        // Add multi-select filter condition here
        if ($filterValue = Mage::app()->getRequest()->getParam('filter')) {
            $collection->addFieldToFilter('your_attribute', array('like' => '%' . $filterValue . '%'));
        }
    
        return $collection;
    }
    
  4. Update your grid column:

    In your grid model’s _prepareColumns() method, update the multi-select column to use the new filter input type:

    public function _prepareColumns()
    {
        parent::_prepareColumns();
    
        $this->addColumn('your_attribute', array(
            'header' => Mage::helper('module')->__('Your Attribute'),
            'index' => 'your_attribute',
            'input_type' => 'filter_input_type',
            // Add other column properties here
        ));
    }
    

Remember to replace 'your_company', 'your_module', and 'your_attribute' with your actual module details.

Conclusion

Handling multi-select values in Magento custom admin-grid modules requires careful manipulation of the submitted data for saving and proper filtering. By following the steps outlined above, you can efficiently store and filter multi-select field values without any issues.

For more advanced techniques and best practices in Magento development, feel free to explore our comprehensive guides at Laravel Company.

Database Extensions Admin Errors

Our network