Magento – Magento 2 Filter product collection by multiple attributes with OR

attributescollection;magento-2.1magento2

In Magento 2.3.3, How Can I Filter Product Collection by Multiple Attributes? First attribute SKU needs to check using "IN" second attribute is yes/no value. I need to filter collection by SKU array OR custom_attribute. I have tried few things but it did not return expected results.

$collection = $layer->getProductCollection()->addAttributeToFilter(
    array(
        array("attribute"=>"sku",array('in' => $skus)),
        array("attribute"=>"universal_fitment","eq"=>1)
    )
);

Best Answer

Please try below.

<?php
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\Collection');
$productCollection->addAttributeToSelect('*');
$queryp = 'product'; 
$querys  = 'product';
$productCollection->addAttributeToFilter(
      [
       ['attribute' => 'sku', 'in' => array('Product 1','Product 2')],
       ['attribute' => 'custom_atribute', 'in' => array('5,4')]
      ]);

$collection = $productCollection->load();

foreach ($collection as $product){
     echo 'Name  =  '.$product->getName().'<br>';
}  

?>

and other case

<?php 

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$products = $objectManager->get('Magento\Catalog\Model\Product')
            ->getCollection()
            //->addAttributeToFilter('is_old',1)
            ->addAttributeToFilter('sku',array('Product 1','Product 2'))
            ->addAttributeToFilter('custom_atribute', array('in' => '5,4'));

echo "<pre>";
print_r($products->getData());

?>

Hope it works!

Related Solutions

Magento – Product Attributes and filtering mechanics

What I did in this case was to rewrite both the model and the corresponding resource, so first rewrite the class Mage_Catalog_Model_Layer_Filter_Attribute to be able to accept multiple values. In my case, I am using commas as a separator, so I can filter like ?my_attribute=1,2,3

In the method apply() I parse the attribute to put the different values in an array:

  public function apply(Zend_Controller_Request_Abstract $request, $filterBlock)
    {
        $filter = $request->getParam($this->_requestVar);
        if (is_array($filter)) {
            return $this;
        }

        // MP customized
        $filter = explode(',', $filter);
        if (count($filter) < 1) {
            return $this;
        } else if ($filter == '') {
            return $this;
        }

        if (count($filter) == 1) {
            $filter = $filter[0];
        }

        if ($filter == '') {
            return $this;
        }

        if ($filter) {
            $this->_initItems();
            $this->_getResource()->applyFilterToCollection($this, $filter);
            $text = '';
            foreach ($filter as $att) {
                ($text == '') ? $text = $this->_getOptionText($att) : $text .= ', '.$this->_getOptionText($att);
            }
            if (count($filter) == 1) {
                $text = $this->_getOptionText($filter);
            }
            $this->getLayer()->getState()->addFilter($this->_createItem($text, $filter));
        }
        // End MP customized
        return $this;
      }

Then in the file Mage_Catalog_Model_Resource_Eav_Mysql4_Layer_Filter_Attribute you have to make sure that you are able to filter for multiple values in your query, so I rewrote the following method like this:

     public function applyFilterToCollection($filter, $value)
    {
        $collection = $filter->getLayer()->getProductCollection();
        $attribute  = $filter->getAttributeModel();
        $connection = $this->_getReadAdapter();
        $tableAlias = $attribute->getAttributeCode() . '_idx';
        $conditions = array(
            "{$tableAlias}.entity_id = e.entity_id",
            $connection->quoteInto("{$tableAlias}.attribute_id = ?", $attribute->getAttributeId()),
            $connection->quoteInto("{$tableAlias}.store_id = ?", $collection->getStoreId()),
            $connection->quoteInto("{$tableAlias}.value IN (?)", $value)
        ); // Added IN (?) notation for arrays


        $collection->getSelect()->join(
            array($tableAlias => $this->getMainTable()),
            join(' AND ', $conditions),
            array()
            // MP Need distinct here to avoid getting the same config product from
            // different basic products when filtering for different values
            // in the same attribute
        )->distinct(true);

        return $this;
    }

Magento – Filter collection by existence of attribute

Say we have a newly created product eav attribute: xxx. It doesn't really matter how it's created. Let's say it is, and it's done correctly.

Now let's assume we've taken a product and from the backend we've set the Xxx input text to something, anything. So we have a single product that has the attribute "xxx" set.

How do I get all the product which don't have that attribute set?

// get all the product that DON'T have the attribute 'xxx' set yet
Mage::getModel('catalog/product')->getCollection()->addAttributeToFilter('xxx', array('null' => true), 'left');

// get all the product that DO have the attribute 'xxx' set
Mage::getModel('catalog/product')->getCollection()->addAttributeToFilter('xxx', array('notnull' => true), 'left');

The third param is "inner" by default. The row sum of these queries should be the number of products you have in DB, so these queries are - and should be - mutually exclusive.

Hope this helps.

Best Answer

Related Solutions

Magento – Product Attributes and filtering mechanics

Magento – Filter collection by existence of attribute

Related Topic