diegovarussa
5/15/2013 - 1:57 AM

Condicionais do addAttributeToFilter

Condicionais do addAttributeToFilter

<?php

// Equals:
$_products->addAttributeToFilter('status', array('eq' => 1));
// Not Equals
$_products->addAttributeToFilter('sku', array('neq' => 'test-product'));
// Like
$_products->addAttributeToFilter('sku', array('like' => 'UX%'));
// Not Like
$_products->addAttributeToFilter('sku', array('nlike' => 'err-prod%'));
// In
$_products->addAttributeToFilter('id', array('in' => array(1,4,98)));
//When using in, the value parameter accepts an array of values.

// Not In	
$_products->addAttributeToFilter('id', array('nin' => array(1,4,98)));
// NULL
$_products->addAttributeToFilter('description', 'null');
// Not NULL
$_products->addAttributeToFilter('description', 'notnull');
// Greater Than
$_products->addAttributeToFilter('id', array('gt' => 5));
// Less Than
$_products->addAttributeToFilter('id', array('lt' => 5));
// Greater Than or Equals To
$_products->addAttributeToFilter('id', array('gteq' => 5));
// Less Than or Equals To
$_products->addAttributeToFilter('id', array('lteq' => 5));