ÉricP ÉricP - 2 years ago 103
PHP Question

addAttributeToFilter and OR condition in Magento's Collection

I'd like to select products depending on several criteria from different attribute.

I know how to user

$collection->addAttributeToFilter('someattribute', array('like' => '%'));

But I'd like to use several attribute for OR condition.


$collection->addAttributeToFilter('someattribute', array('like' => 'value'));`


$collection->addAttributeToFilter('otherattribute', array('like' => 'value'));`

To get products which either 'someattribute' OR 'otherattribute' set to 'value'

Is it possible?

Answer Source

yes it is.

        array('attribute'=> 'someattribute','like' => 'value'),
        array('attribute'=> 'otherattribute','like' => 'value'),
        array('attribute'=> 'anotherattribute','like' => 'value'),

see also in Magento Wiki

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download