Add an AND condition inside an OR condition

Question

I have a collection that I have to filter according to multiple strings in one field. The trick is that one of the possible values in that field needs to be picked only if another field's value meets a certain condition. For example:

$this->addFieldToFilter(
  'my_field1', 
  array(
    'val1', |
    'val2', |  <--- This is the OR part
    'val3', |
    'val4 AND my_field2 like 'my_field2_val' // <-- This is the tricky part
   )
);

Can any of you guys help me? PS: My collection is a flat one not EAV.

Fabian Blechschmidt · Answer 1 · 2014-10-20T14:25:29.150

4

Works only for EAV collections - I think.

You can add ANDs and ORs like this:

OR

$collection->addAttributeToFilter(
    array(
        array('attribute'=> 'someattribute','like' => 'value'),
        array('attribute'=> 'otherattribute','like' => 'value'),
        array('attribute'=> 'anotherattribute','like' => 'value'),
    )
);

AND inside OR

$collection->addAttributeToFilter(
    array(
        array( // AND
            array('attribute'=> 'someattribute','like' => 'value'),
            array('attribute'=> 'otherattribute','like' => 'value'),
        ),
        array('attribute'=> 'anotherattribute','like' => 'value'),
    )
);

So just stack the arrays.

edited Oct 20 '14 at 14:25

answered Oct 20 '14 at 13:50

Fabian Blechschmidt

35,388
8
75
182

I have the following: $this->addFieldToFilter( array( array('attribute' => 'event_code', array('eq'=>'val1')), array('attribute' => 'event_code', array('eq'=>'val2')), ) ) And the resulting query is something like: SELECT ..... AND (Array = '') LIMIT 50 – Denis Rendler Oct 20 '14 at 13:55
The collection is flat. Could that be why I cannot stack the arrays? – Denis Rendler Oct 20 '14 at 14:01
1

@DenisR Instead of array('eq'=>'val1') it should be just 'eq'=>'val1'. – Marius Oct 20 '14 at 14:01
Thanks @marius but still not working. the generated query is the same. – Denis Rendler Oct 20 '14 at 14:15
I think this only works on EAV collections. Please try with addAttributeToFilter. If this is not available due to flat, you are out of luck afaik. – Fabian Blechschmidt Oct 20 '14 at 14:20
@FabianBlechschmidt, I already tried it and it throws an error. I am really amazed and disappointed of how restricted is the magento ORM. – Denis Rendler Oct 20 '14 at 14:23
yep. I know this feeling. The alternative is $collection->getSelect()->doWhateverYouWantWithThisZend_Db_SelectObject – Fabian Blechschmidt Oct 20 '14 at 14:25
Thanks @FabianBlechschmidt, I thinks that's my only solution. Either that or write the query by hand. – Denis Rendler Oct 21 '14 at 05:46
Be very careful when you write it by hand and make sure to not add a SQL injection issue. – Fabian Blechschmidt Oct 21 '14 at 11:50

Add an AND condition inside an OR condition

1 Answers1

Works only for EAV collections - I think.

OR

AND inside OR