Magento filter collection by attribute option

Question

I'm pretty new to Magento and I'm trying to figure out how to filter a collection of products. Here's the situation: I have a product that have a 'style', which is a product's attribute (example of style: brass). I need to get all other products that have the style 'brass'.

I've done a few research and discovered the addFieldToFilter() method, but it doesn't seem to be working (or, most likely, I'm not using it properly):

$same_style_collection = Mage::getModel('catalog/product')->getCollection()
    ->addFieldToFilter(array(array('attribute' => 'name', 'like' => 'brass')));

Can anyone help me? It would be greatly appreciated.

score 6 · Answer 1 · answered May 14 '13 at 19:26

6

Have you tried like this?

$collection = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToFilter('style', 'brass');

This will give you all the products which have an attribute style with value brass.

When you want to filter data from EAV collection you use addAttributeToFilter, and when you want to filter data from Flat table collection you use addFieldToFilter.

answered May 14 '13 at 19:26

Kalpesh

5,635
2
23
39

That didn't work for me. – SimCity May 21 '13 at 15:38

score 0 · Answer 2 · answered May 14 '13 at 19:17

$collection = Mage::getModel('catalog/product')
                        ->getCollection()
                        ->addAttributeToSelect('*');

foreach ($collection as $product) {


    echo $product->getName() . "<br />";

    }

With such getter setter methods you can access every product attributes like I have done here.

Magento filter collection by attribute option

2 Answers2