Magento addAttributeToFilter with Multiple Select

magento addattribute
Adam Moss picture Adam Moss · May 9, 2012 · Viewed 8.5k times · Source

I'm having troubles using addAttributeToFilter on Magento Multiple select attributes.

I have a multiple select attribute for car makes, so the content is 'Audi', 'BMW' and so on. In my example I have a tyre product which I have selected 5 makes for from the multiple select.

I want to display products which have the make 'BMW' as one of their selected fields.

I have tried the following all of which are not working:

$products->addAttributeToFilter('make', array('like' => '%BMW%'));  
$products->addFieldToFilter('make', array('like' => '%BMW%'));  
$products->addAttributeToFilter('make', array('like' => '%38%')); // id of the attribute option

Nothing seems to work.

Answer

Alex Hadley picture Alex Hadley · May 9, 2012

The solution is to use a Find In Set query such as:

$this->_productCollection->addAttributeToFilter("make", array("finset"=>"38"));

A discussion can be seen here: http://www.magentocommerce.com/boards/viewthread/201312/

And a list of different options: http://www.magentocommerce.com/knowledge-base/entry/magento-for-dev-part-8-varien-data-collections

Related questions

How do I filter a magento collection by a select drop-down attribute?

In magento, I have an attribute called cl_designer, which is a select drop-down option. I want to filter the products collection on it, like this: $collection = Mage::getModel('catalog/product')->getCollection(); $collection->addAttributeToFilter('cl_designer', array(…

Read More
Class 'DOMDocument' not found

I've found an error on a page in my Magento application; it always show this message error when I visit it: Fatal error: Class 'DOMDocument' not found in /home/.../lib/Zend/Feed/Abstract.php on line 95 Can you give me …

Read More
There has been an error processing your request, Error log record number

I installed Magento, logged in admin panel. But if I press on any link to open let say CMS pages or users configuration, I get error like this: There has been an error processing your request Exception printing is disabled …

Read More