StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POOR and AND STATEMENT addAttributeToFilter magento
text
Body
copied!<p>I have created the following code.</p> <pre><code>$todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT); $tomorrow = mktime(0, 0, 0, date('m'), date('d')+1, date('y')); $dateTomorrow = date('m/d/y', $tomorrow); $collection = Mage::getResourceModel('catalog/product_collection'); $collection->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds()); $collection = $this->_addProductAttributesAndPrices($collection) ->addStoreFilter() ->addAttributeToFilter('special_price', array('neq' => "")) ->addAttributeToFilter('special_from_date', array('date' => true, 'to' => $todayDate)) ->addAttributeToFilter('special_to_date', array('or'=> array(0 => array('date' => true, 'from' => $dateTomorrow), 1 => array('is' => new Zend_Db_Expr('null')))), 'left'); </code></pre> <p>This is working fine. But what i want is to use the OR statement right now. I thought i could fix it with this:</p> <pre><code>$collection->addAttributeToFilter(array( array('attribute'=> 'someattribute','like' => 'value'), array('attribute'=> 'otherattribute','like' => 'value'), array('attribute'=> 'anotherattribute','like' => 'value'), )); </code></pre> <p>But no succes. So my question is how to add OR statement to this.</p> <pre><code>$todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT); $tomorrow = mktime(0, 0, 0, date('m'), date('d')+1, date('y')); $dateTomorrow = date('m/d/y', $tomorrow); $collection = Mage::getResourceModel('catalog/product_collection'); $collection->setVisibility(Mage::getSingleton('catalog/product_visibility')->getVisibleInCatalogIds()); $collection = $this->_addProductAttributesAndPrices($collection) ->addStoreFilter() ->addAttributeToFilter('special_price', array('neq' => "")) ->addAttributeToFilter('special_from_date', array('date' => true, 'to' => $todayDate)) ->addAttributeToFilter('special_to_date', array('or'=> array(0 => array('date' => true, 'from' => $dateTomorrow), 1 => array('is' => new Zend_Db_Expr('null')))), 'left'); </code></pre> <p>OR</p> <p>Thank you.</p> <p>Great, Lex</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload