Magento 1.9 collection multi conditions

Question

I read many posts and articles but still didn't find a solution.

I would like to filter my product collection with this condition:

... 
WHERE ('supplier_id' = 1 AND 'product_type' = 'first_type') 
OR ('supplier_id' = 2 AND 'product_type' = 'another_type') 
...

Is it possible to achieve this using addFieldToFilter method?

Any other suggestions are welcome as well!

Answer 1

Can you try by this way, I think this will solve your problem

->getSelect()->where(" (`Your attribute` = 'Value' AND `Your attribute` = 'Value') OR (`Your attribute` = 'Value' AND `Your attribute` = 'Value')");

In your case in the getSelect() could be:

->getSelect()->where("(`supplier_id` = '1' AND `product_type` = 'first_type') OR (`supplier_id` = '2' AND `product_type` = 'another_type')");