SQL Query IN and NOT IN

Posted on July 6, 2017, 11:59 am, by admin, under Magento 1.x, Tips.

Magento uses keywords in for IN and nin for NOT IN

...
 
$productIds = array(1251,1253,1256);
 
if ($column->getFilter()->getValue()) {
      $this->getCollection()->addFieldToFilter('entity_id', array('in'=>$productIds));
}
      else {
     $this->getCollection()->addFieldToFilter('entity_id', array('nin'=>$productIds));
}
...
Comment (RSS)  |  Trackback

Leave a Reply

«
»