How to get magento collection by next condition:
where (url_from = "1" AND url_to = "2")
OR (url_from = "2" AND url_to = "1")
Thank you!
1 Answer
you want something like that
$_products->addFieldToFilter('url_from', array('in' => array(1,2)));
$_products->addFieldToFilter('url_to', array('in' => array(2,1)));
answered Apr 27, 2016 at 9:53
-
-
@qaisar can you please help me in this question magento.stackexchange.com/questions/112860/…– MujahidhCommented Apr 27, 2016 at 10:09
-
-
Trying to figure out, it's kinda complicated... while your solution is easy and would probably work fine in this case (it's unlikely I guess that to and from are equal), it is not logically correct, since it would be true even for combinations that shouldn't be true, like
url_from=1 AND url_to=1.– fmrngCommented Apr 27, 2016 at 11:49 -
1Sorry, but I realised after I posted that what it was doing was
WHERE ((url_from = '1') OR (url_to = '2')) AND ((url_from = '2') OR (url_to = '1')), which is obviously not correct– fmrngCommented Apr 27, 2016 at 11:58
$_products->addFieldToFilter('url_from', array('in' => array(1,2))); $_products->addFieldToFilter('url_to', array('in' => array(2,1)));